DBA Data[Home] [Help]

APPS.CE_PMT_CALLOUT_PKG dependencies on IBY_FD_PAYMENTS_V

Line 56: iby_fd_payments_v pmts

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;

Line 61: l_payment_reference_number IBY_FD_PAYMENTS_V.payment_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