708: || 'icr.group_by_pay_service_request, '
709: || 'icr.group_by_rfc , '
710: || 'icr.group_by_payment_method '
711: || 'FROM '
712: || 'IBY_PAYMENTS_SEC_V pmts, '
713: || 'IBY_INSTR_CREATION_RULES icr, '
714: || 'IBY_PAY_SERVICE_REQUESTS prq, '
715: || 'IBY_SYS_PMT_PROFILES_B sppf, '
716: || 'IBY_ACCT_PMT_PROFILES_B appf, '
3255: IBY_PAY_INSTRUCTIONS_ALL pmt_instr,
3256: IBY_PAYMENT_PROFILES prof,
3257: IBY_TRANSMIT_CONFIGS_VL txconf,
3258: IBY_TRANSMIT_PROTOCOLS_VL txproto,
3259: IBY_PAYMENTS_SEC_V pmt
3260: WHERE
3261: pmt_instr.payment_instruction_id = p_instr_id
3262: AND pmt.payment_instruction_id = pmt_instr.payment_instruction_id
3263: AND val.validation_set_code = val_asgn.validation_set_code