APPS.AP_PMT_CALLOUT_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 984: , invoice_id iby_docs_payable_all.calling_app_doc_unique_ref2%TYPE

980: TYPE prob_pay_rec IS RECORD
981: ( payment_id iby_payments_all.payment_id%TYPE
982: , payment_reference_number iby_payments_all.payment_reference_number%TYPE
983: , payment_instruction_id iby_payments_all.payment_instruction_id%TYPE
984: , invoice_id iby_docs_payable_all.calling_app_doc_unique_ref2%TYPE
985: , payment_num iby_docs_payable_all.calling_app_doc_unique_ref3%TYPE
986: , prob_type varchar2(200));
987:
988: TYPE prob_pmt_tab IS TABLE OF prob_pay_rec INDEX BY BINARY_INTEGER;

Line 985: , payment_num iby_docs_payable_all.calling_app_doc_unique_ref3%TYPE

981: ( payment_id iby_payments_all.payment_id%TYPE
982: , payment_reference_number iby_payments_all.payment_reference_number%TYPE
983: , payment_instruction_id iby_payments_all.payment_instruction_id%TYPE
984: , invoice_id iby_docs_payable_all.calling_app_doc_unique_ref2%TYPE
985: , payment_num iby_docs_payable_all.calling_app_doc_unique_ref3%TYPE
986: , prob_type varchar2(200));
987:
988: TYPE prob_pmt_tab IS TABLE OF prob_pay_rec INDEX BY BINARY_INTEGER;
989: l_prob_pmt_list prob_pmt_tab;

Line 1867: from ap_invoices_all inv,iby_docs_payable_all idp

1863: WHEN inv.invoice_type_lookup_code = 'PAYMENT REQUEST' AND SIGN(inv.vendor_id)= -1
1864: THEN nvl(pv.vendor_id,-99) --bug 8657535. Changed -99 to nvl(pv.vendor_id,-99)
1865: ELSE nvl(vendor_id,-99)
1866: END --Bug7493630 and Bug 8260736 (8348480)
1867: from ap_invoices_all inv,iby_docs_payable_all idp
1868: where inv.invoice_id=idp.calling_app_doc_unique_ref2
1869: and idp.payment_id=iby.payment_id
1870: and idp.calling_app_doc_unique_ref1=l_checkrun_id
1871: and rownum=1