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.AP_CREATE_PAY_SCHEDS_PKG dependencies on IBY_PAYEE_ASSIGNED_BANKACCT_V

Line 1358: --iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */

1354: CURSOR c_orig_bank_acct_vendor IS --BUG 1274099, checks at the vendor level
1355: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7261556/7375488
1356: FROM ap_payment_schedules aps,
1357: ap_invoices ai,
1358: --iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1359: po_vendors pv
1360: WHERE ai.invoice_id = p_invoice_id
1361: AND ai.vendor_id = pv.vendor_id -- changed for bug 9531288
1362: --AND pv.party_id = ipab.party_id(+)

Line 1365: AND EXISTS (SELECT 'x' FROM iby_payee_assigned_bankacct_v IPAB WHERE

1361: AND ai.vendor_id = pv.vendor_id -- changed for bug 9531288
1362: --AND pv.party_id = ipab.party_id(+)
1363: AND ai.invoice_id = aps.invoice_id
1364: --AND ipab.ext_bank_account_id = aps.external_bank_account_id
1365: AND EXISTS (SELECT 'x' FROM iby_payee_assigned_bankacct_v IPAB WHERE
1366: pv.party_id = ipab.party_id (+) AND ipab.ext_bank_account_id =
1367: aps.external_bank_account_id ) ;
1368:
1369: -- bug 1274099 checks for the vendor site level

Line 1375: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */

1371: CURSOR c_orig_bank_acct_vend_site IS
1372: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1373: FROM ap_payment_schedules aps,
1374: ap_invoices ai,
1375: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1376: po_vendors pv
1377: WHERE ai.invoice_id = p_invoice_id
1378: AND ai.vendor_id = pv.vendor_id
1379: AND pv.party_id = ipab.party_id(+)