eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on IBY_PAYMENTS_ALL

Line 170: from iby_payments_all

166: AND calling_app_id=200
167: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
168: AND document_status = 'PAYMENT_CREATED'
169: AND payment_id in (select payment_id
170: from iby_payments_all
171: where payment_instruction_id = p_instruction_id);
172:
173:
174:

Line 399: iby_payments_all ibypmt

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

Line 749: FROM iby_payments_all

745: -- Bug : 11740157 : Validate only active payments.
746: CURSOR get_payee_address_csr(p_payment_id NUMBER)
747: IS
748: SELECT payee_address1, payee_address2, payee_address3, payee_address4, payee_city, payee_postal_code, payee_state
749: FROM iby_payments_all
750: WHERE
751: PAYMENT_ID=p_payment_id
752: AND payment_status = 'INSTRUCTION_CREATED' ;
753:

Line 1680: from iby_payments_all ipa,

1676: into l_rfc_id,
1677: l_bank_account_id,
1678: l_bank_branch_id,
1679: l_bank_account_name
1680: from iby_payments_all ipa,
1681: ce_bank_accounts cba,
1682: hz_code_assignments hca
1683: where ipa.payment_id = p_payment_id
1684: and ipa.internal_bank_account_id = cba.bank_account_id(+)