APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on IBY_PAYMENTS_ALL

Line 168: from iby_payments_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
168: from iby_payments_all
169: where payment_instruction_id = p_instruction_id);
170:
171:
172:

Line 397: iby_payments_all ibypmt

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
401: AND ibydocpay.calling_app_id=200

Line 746: FROM iby_payments_all

742:
743: CURSOR get_payee_address_csr(p_payment_id NUMBER)
744: IS
745: SELECT payee_address1, payee_address2, payee_address3, payee_address4, payee_city, payee_postal_code, payee_state
746: FROM iby_payments_all
747: WHERE
748: PAYMENT_ID=p_payment_id;
749:
750: l_payeeadd_rec get_payee_address_csr%ROWTYPE ;

Line 1667: from iby_payments_all ipa,

1663: into l_rfc_id,
1664: l_bank_account_id,
1665: l_bank_branch_id,
1666: l_bank_account_name
1667: from iby_payments_all ipa,
1668: ce_bank_accounts cba,
1669: hz_code_assignments hca
1670: where ipa.payment_id = p_payment_id
1671: and ipa.internal_bank_account_id = cba.bank_account_id(+)