APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on IBY_DOCS_PAYABLE_ALL

Line 159: -- Get Inovice ID From IBY_DOCS_PAYABLE_ALL

155: x_error_code OUT NOCOPY NUMBER,
156: x_error_mesg OUT NOCOPY VARCHAR2
157: )IS
158:
159: -- Get Inovice ID From IBY_DOCS_PAYABLE_ALL
160: CURSOR all_invoices_csr(p_instruction_id NUMBER)
161: IS
162: SELECT calling_app_doc_unique_ref2
163: FROM IBY_DOCS_PAYABLE_ALL -- added all

Line 163: FROM IBY_DOCS_PAYABLE_ALL -- added all

159: -- Get Inovice ID From IBY_DOCS_PAYABLE_ALL
160: CURSOR all_invoices_csr(p_instruction_id NUMBER)
161: IS
162: SELECT calling_app_doc_unique_ref2
163: FROM IBY_DOCS_PAYABLE_ALL -- added all
164: WHERE upper(document_type)='STANDARD'
165: AND calling_app_id=200
166: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
167: AND payment_id in (select payment_id

Line 396: FROM iby_docs_payable_all ibydocpay,

392: -- Get Payment Amount And Instruction id Corresponding To Invoice Id
393: CURSOR payid_amt_csr(p_invoice_id VARCHAR2, p_payment_id number)
394: IS
395: SELECT ibypmt.payment_amount
396: FROM iby_docs_payable_all ibydocpay,
397: iby_payments_all ibypmt
398: WHERE ibydocpay.payment_id = p_payment_id
399: AND ibydocpay.calling_app_doc_unique_ref2 = p_invoice_id
400: AND ibydocpay.payment_id=ibypmt.payment_id

Line 926: l_payment_reason_code iby_docs_payable_all.payment_reason_code%TYPE;

922: x_error_mesg OUT NOCOPY VARCHAR2
923: )IS
924:
925: l_message VARCHAR2(1000);
926: l_payment_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
927: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;
928: l_module_name VARCHAR2(200) := g_module_name || 'PAY_TAX_BENEFIT';
929:
930: BEGIN

Line 940: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all

936: SELECT idpa.payment_reason_code,
937: asup.vendor_type_lookup_code
938: INTO l_payment_reason_code,
939: l_vendor_type_lookup_code
940: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all
941: ap_invoices_all aia,
942: ap_suppliers asup
943: WHERE idpa.payment_id=p_payment_id
944: AND idpa.calling_app_doc_unique_ref2 = p_invoice_id