52: IS
53: SELECT docs.calling_app_doc_ref_number,
54: pmts.payment_reference_number
55: FROM iby_fd_docs_payable_v docs,
56: iby_fd_payments_v pmts
57: WHERE docs.completed_pmts_group_id = cs_completed_pmts_group_id
58: AND docs.payment_id = pmts.payment_id;
59:
60: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
57: WHERE docs.completed_pmts_group_id = cs_completed_pmts_group_id
58: AND docs.payment_id = pmts.payment_id;
59:
60: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
61: l_payment_reference_number IBY_FD_PAYMENTS_V.payment_reference_number%TYPE;
62: BEGIN
63: OPEN c_completed_transfers(p_completed_pmts_group_id);
64: LOOP
65: FETCH c_completed_transfers into