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: -- Bug : 11740157 : Validate only active documents.
161: CURSOR all_invoices_csr(p_instruction_id NUMBER)
162: IS
163: SELECT calling_app_doc_unique_ref2

Line 164: FROM IBY_DOCS_PAYABLE_ALL -- added all

160: -- Bug : 11740157 : Validate only active documents.
161: CURSOR all_invoices_csr(p_instruction_id NUMBER)
162: IS
163: SELECT calling_app_doc_unique_ref2
164: FROM IBY_DOCS_PAYABLE_ALL -- added all
165: WHERE upper(document_type)='STANDARD'
166: AND calling_app_id=200
167: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
168: AND document_status = 'PAYMENT_CREATED'

Line 398: FROM iby_docs_payable_all ibydocpay,

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

Line 930: l_payment_reason_code iby_docs_payable_all.payment_reason_code%TYPE;

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

Line 944: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all

940: SELECT idpa.payment_reason_code,
941: asup.vendor_type_lookup_code
942: INTO l_payment_reason_code,
943: l_vendor_type_lookup_code
944: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all
945: ap_supplier_sites_all asst,
946: ap_suppliers asup
947: WHERE idpa.payment_id=p_payment_id
948: AND idpa.calling_app_doc_unique_ref2 = p_invoice_id

Line 1441: FROM IBY_DOCS_PAYABLE_ALL

1437: CURSOR get_pay_alone_flag_csr(p_invoice_id NUMBER, p_payment_id NUMBER)
1438: IS
1439: SELECT exclusive_payment_flag,
1440: calling_app_doc_ref_number
1441: FROM IBY_DOCS_PAYABLE_ALL
1442: WHERE calling_app_doc_unique_ref2 = p_invoice_id
1443: AND document_status = 'PAYMENT_CREATED'
1444: AND payment_id = p_payment_id
1445: AND calling_app_id=200

Line 1603: INTO l_invoice_num FROM IBY_DOCS_PAYABLE_ALL

1599: l_message := 'Validating Account Type, Parameters: p_format_name = ' || p_format_name || ', p_bank_account_type = ' || p_bank_account_type ;
1600: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1601:
1602: SELECT calling_app_doc_ref_number
1603: INTO l_invoice_num FROM IBY_DOCS_PAYABLE_ALL
1604: WHERE calling_app_doc_unique_ref2 = p_invoice_id
1605: AND payment_id = p_payment_id
1606: AND calling_app_id=200
1607: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');