APPS.CE_PMT_CALLOUT_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 14: FROM iby_fd_docs_payable_v docs

10: IS
11: CURSOR c_rejected_transfers (cs_rejected_docs_group_id NUMBER)
12: IS
13: SELECT docs.calling_app_doc_ref_number
14: FROM iby_fd_docs_payable_v docs
15: WHERE docs.rejected_docs_group_id = cs_rejected_docs_group_id;
16:
17: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
18: l_result varchar2(100);

Line 55: FROM iby_fd_docs_payable_v docs,

51: CURSOR c_completed_transfers (cs_completed_pmts_group_id NUMBER)
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:

Line 99: FROM iby_fd_docs_payable_v docs

95: IS
96: CURSOR c_voided_transfers (cs_payment_id NUMBER)
97: IS
98: SELECT docs.calling_app_doc_ref_number
99: FROM iby_fd_docs_payable_v docs
100: WHERE docs.payment_id = cs_payment_id;
101:
102: l_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%TYPE;
103: