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_EXT_BANKACCT_PUB dependencies on IBY_PMT_INSTR_USES_ALL

Line 1347: FROM iby_pmt_instr_uses_all instrument,

1343: AND party_id = p_branch_id;
1344:
1345: CURSOR c_supplier(p_acct_id NUMBER) IS
1346: SELECT owners.account_owner_party_id
1347: FROM iby_pmt_instr_uses_all instrument,
1348: IBY_ACCOUNT_OWNERS owners,
1349: iby_external_payees_all payees
1350: WHERE
1351: owners.primary_flag = 'Y' AND

Line 2334: FROM iby_pmt_instr_uses_all instrument,

2330: AND BRANCH_PARTY_ID = p_branch_id;
2331:
2332: CURSOR c_supplier(p_acct_id NUMBER) IS
2333: SELECT owners.account_owner_party_id
2334: FROM iby_pmt_instr_uses_all instrument,
2335: IBY_ACCOUNT_OWNERS owners,
2336: iby_external_payees_all payees
2337: WHERE
2338: owners.primary_flag = 'Y' AND

Line 5575: SELECT ext_pmt_party_id FROM IBY_PMT_INSTR_USES_ALL WHERE

5571: SELECT org_id INTO l_org_id FROM iby_external_payees_all
5572: WHERE org_id IS NOT NULL AND org_type IS NOT null
5573: AND
5574: ext_payee_id IN(
5575: SELECT ext_pmt_party_id FROM IBY_PMT_INSTR_USES_ALL WHERE
5576: PAYMENT_FLOW = 'DISBURSEMENTS'
5577: AND INSTRUMENT_TYPE = 'BANKACCOUNT'
5578: AND payment_function = 'PAYABLES_DISB'
5579: AND INSTRUMENT_ID = p_ext_bank_acct_id )

Line 5589: SELECT ext_pmt_party_id FROM IBY_PMT_INSTR_USES_ALL WHERE

5585: SELECT org_id INTO l_org_id FROM iby_external_payees_all
5586: WHERE org_id IS NOT NULL AND org_type IS NOT null
5587: AND
5588: ext_payee_id IN(
5589: SELECT ext_pmt_party_id FROM IBY_PMT_INSTR_USES_ALL WHERE
5590: PAYMENT_FLOW = 'DISBURSEMENTS'
5591: AND INSTRUMENT_TYPE = 'BANKACCOUNT'
5592: AND payment_function = 'PAYABLES_DISB'
5593: AND INSTRUMENT_ID = p_ext_bank_acct_id )