UPDATE
        payment_order
    SET
        group_payment_sending_id=?
    WHERE
        id IN (
            SELECT
                DISTINCT paymentord1_.id
            FROM
                payment_order paymentord1_
            LEFT OUTER JOIN
                payment paymentpc2_
                    ON paymentord1_.payment_id=paymentpc2_.id,
                payment paymentpc3_
            WHERE
                paymentord1_.payment_id=paymentpc3_.id
                AND (
                    paymentord1_.payment_cord_order_id IS NULL
                )
                AND (
                    paymentord1_.payment_state IN (
                        'INIT' , 'INIT_ONLY_USER' , 'EDIT' , 'EDIT_ONLY_USER' , 'EDIT_ERROR' , 'EDIT_ERROR_ONLY_USER' , 'PARTIAL_APPROVED'
                    )
                    OR paymentord1_.payment_state='APPROVED'
                    AND paymentpc3_.internal_flag=1
                    AND paymentord1_.trx_date>=?
                    OR paymentord1_.payment_state='APPROVED'
                    AND paymentpc3_.internal_flag=0
                    AND paymentord1_.trx_date>=?
                )
                AND paymentpc3_.medium='e_bank'
                AND (
                    (
                        paymentpc2_.money_account_id IS NULL
                    )
                    AND (
                        EXISTS (
                            SELECT
                                fileupload6_.id
                            FROM
                                file_upload_meta_data fileupload6_
                            LEFT OUTER JOIN
                                user_context usercontex7_
                                    ON fileupload6_.user_context_id=usercontex7_.id
                            WHERE
                                usercontex7_.authentication_object_id=?
                                AND fileupload6_.id=paymentord1_.file_upload_id
                        )
                    )
                    OR (
                        EXISTS (
                            SELECT
                                pos_id
                            FROM
                                afs_obj_macc moneyaccou8_
                            INNER JOIN
                                afs_obj_pos moneyaccou8_1_
                                    ON moneyaccou8_.pos_id=moneyaccou8_1_.obj_id
                            INNER JOIN
                                afs_obj moneyaccou8_2_
                                    ON moneyaccou8_.pos_id=moneyaccou8_2_.id
                            WHERE
                                moneyaccou8_2_.close_date IS NULL
                                AND moneyaccou8_2_.bu_id IN (
                                    ?, ?
                                )
                                AND  EXISTS (
                                    SELECT
                                        NULL
                                    FROM
                                        afs_obj_access   oa   ,
                                        afs_login_access la    ,
                                        authentication_object lo
                                    WHERE
                                        oa.access_id        = la.access_id
                                        AND lo.id               = la.login_id
                                        AND lo.close_date IS NULL
                                        AND oa.obj_id           = moneyaccou8_1_.obj_id
                                        AND oa.bu_id            IN (
                                            ?, ?
                                        )
                                        AND la.bu_id            IN (
                                            ?, ?
                                        )
                                        AND oa.obj_type_intl_id = 'pos'
                                        AND la.login_id    = ?
                                )
                                AND pos_id=paymentpc2_.money_account_id
                                AND (
                                    EXISTS (
                                        SELECT
                                            obj_id
                                        FROM
                                            afs_obj_ips ipspc9_
                                        INNER JOIN
                                            afs_obj ipspc9_1_
                                                ON ipspc9_.obj_id=ipspc9_1_.id
                                        WHERE
                                            ipspc9_1_.close_date IS NULL
                                            AND ipspc9_1_.bu_id IN (
                                                ?, ?
                                            )
                                            AND  EXISTS (
                                                SELECT
                                                    NULL
                                                FROM
                                                    afs_obj_access   oa   ,
                                                    afs_login_access la    ,
                                                    authentication_object lo
                                                WHERE
                                                    oa.access_id        = la.access_id
                                                    AND lo.id               = la.login_id
                                                    AND lo.close_date IS NULL
                                                    AND oa.obj_id           = ipspc9_.obj_id
                                                    AND oa.bu_id            IN (
                                                        ?, ?
                                                    )
                                                    AND la.bu_id            IN (
                                                        ?, ?
                                                    )
                                                    AND oa.obj_type_intl_id = 'ips'
                                                    AND la.login_id    = ?
                                            )
                                            AND (
                                                ipspc9_.obj_id IN (
                                                    SELECT
                                                        /*+cardinality(table_array 1)*/ column_value
                                                    FROM
                                                        TABLE(?) table_array
                                                )
                                            )
                                            AND (
                                                moneyaccou8_1_.cont_id IN (
                                                    SELECT
                                                        portfolios10_.portfolio_set_id
                                                    FROM
                                                        ips_portfolio portfolios10_
                                                    WHERE
                                                        afs_obj_ips.obj_id=portfolios10_.afs_obj_ips_id
                                                )
                                            )
                                        )
                                    )
                                )
                        )
                        AND (
                            paymentpc2_.internal_flag=0
                            AND paymentpc2_.salary_payment=1
                            AND 1=nvl((SELECT
                                loginfctla11_.val_nr
                            FROM
                                afs_login_fctl_access loginfctla11_,
                                afs_code_access codeaccess12_
                            WHERE
                                loginfctla11_.access_id=codeaccess12_.id
                                AND loginfctla11_.login_id=?
                                AND loginfctla11_.bu_id=?
                                AND codeaccess12_.intl_id=?
                                AND loginfctla11_.obj_id=paymentpc2_.money_account_id), nvl((SELECT
                                loginfctla13_.val_nr
                            FROM
                                afs_login_fctl_access loginfctla13_,
                                afs_code_access codeaccess14_
                            WHERE
                                loginfctla13_.access_id=codeaccess14_.id
                                AND loginfctla13_.login_id=?
                                AND loginfctla13_.bu_id=?
                                AND codeaccess14_.intl_id=?
                                AND (loginfctla13_.obj_id IS NULL)), 0))
                            OR paymentpc2_.salary_payment=0
                            AND paymentpc2_.internal_flag=0
                            AND 1=nvl((SELECT
                                loginfctla15_.val_nr
                            FROM
                                afs_login_fctl_access loginfctla15_,
                                afs_code_access codeaccess16_
                            WHERE
                                loginfctla15_.access_id=codeaccess16_.id
                                AND loginfctla15_.login_id=?
                                AND loginfctla15_.bu_id=?
                                AND codeaccess16_.intl_id=?
                                AND loginfctla15_.obj_id=paymentpc2_.money_account_id), nvl((SELECT
                                loginfctla17_.val_nr
                            FROM
                                afs_login_fctl_access loginfctla17_,
                                afs_code_access codeaccess18_
                            WHERE
                                loginfctla17_.access_id=codeaccess18_.id
                                AND loginfctla17_.login_id=?
                                AND loginfctla17_.bu_id=?
                                AND codeaccess18_.intl_id=?
                                AND (loginfctla17_.obj_id IS NULL)), 0))
                            OR paymentpc2_.internal_flag=1
                            AND 1=nvl((SELECT
                                loginfctla19_.val_nr
                            FROM
                                afs_login_fctl_access loginfctla19_,
                                afs_code_access codeaccess20_
                            WHERE
                                loginfctla19_.access_id=codeaccess20_.id
                                AND loginfctla19_.login_id=?
                                AND loginfctla19_.bu_id=?
                                AND codeaccess20_.intl_id=?
                                AND loginfctla19_.obj_id=paymentpc2_.money_account_id), nvl((SELECT
                                loginfctla21_.val_nr
                            FROM
                                afs_login_fctl_access loginfctla21_,
                                afs_code_access codeaccess22_
                            WHERE
                                loginfctla21_.access_id=codeaccess22_.id
                                AND loginfctla21_.login_id=?
                                AND loginfctla21_.bu_id=?
                                AND codeaccess22_.intl_id=?
                                AND (loginfctla21_.obj_id IS NULL)), 0))
                        )
                    )
                    AND (
                        paymentord1_.id IN (
                            SELECT
                                /*+cardinality(table_array 1)*/ column_value
                            FROM
                                TABLE(?) table_array
                        )
                    )
      AND paymentord1_.trx_date>=?
 )