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.POS_SBD_IBY_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 1008: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,

1004: l_org_id number;
1005:
1006: cursor l_max_p_cur is
1007: select max(uses.order_of_preference)
1008: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1009: iby_ext_bank_accounts act, ap_supplier_sites_all pvsa
1010: where uses.instrument_type = 'BANKACCOUNT'
1011: AND sysdate between NVL(act.start_date,sysdate) AND NVL(act.end_date,sysdate)
1012: and payee.ext_payee_id = uses.ext_pmt_party_id

Line 1025: select payee.object_version_number, payee.ext_payee_id from iby_external_payees_all payee

1021:
1022: l_priority number;
1023:
1024: cursor l_payee_cur is
1025: select payee.object_version_number, payee.ext_payee_id from iby_external_payees_all payee
1026: where payee.ext_payee_id = l_party_id
1027: and payee.org_id is null
1028: and payee.party_site_id is null
1029: and payee.supplier_site_id = p_vendor_site_id;

Line 1034: from iby_external_payees_all payee, iby_pmt_instr_uses_all uses

1030: l_cur_payee_rec l_payee_cur%ROWTYPE;
1031:
1032: cursor l_payee_assignment_cur is
1033: select uses.object_version_number
1034: from iby_external_payees_all payee, iby_pmt_instr_uses_all uses
1035: where payee.ext_payee_id = l_party_id
1036: and payee.org_id is null
1037: and payee.party_site_id is null
1038: and payee.supplier_site_id = p_vendor_site_id