25639: IBY_PAYMENT_PROFILES prof,
25640: /* Remit advice related */
25641: IBY_REMIT_ADVICE_SETUP remit_advice,
25642: /* Bank instruction related */
25643: IBY_BANK_INSTRUCTIONS_VL bank_instr1,
25644: IBY_BANK_INSTRUCTIONS_VL bank_instr2
25645:
25646: WHERE
25647: /* profile and remit advice */
25640: /* Remit advice related */
25641: IBY_REMIT_ADVICE_SETUP remit_advice,
25642: /* Bank instruction related */
25643: IBY_BANK_INSTRUCTIONS_VL bank_instr1,
25644: IBY_BANK_INSTRUCTIONS_VL bank_instr2
25645:
25646: WHERE
25647: /* profile and remit advice */
25648: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_index) = prof.payment_profile_id