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_PMT_INSTR_USES_ALL

Line 1026: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,

1022: l_org_id number;
1023:
1024: cursor l_max_p_cur is
1025: select max(uses.order_of_preference)
1026: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1027: iby_ext_bank_accounts act, ap_supplier_sites_all pvsa
1028: where uses.instrument_type = 'BANKACCOUNT'
1029: AND sysdate between NVL(act.start_date,sysdate) AND NVL(act.end_date,sysdate)
1030: and payee.ext_payee_id = uses.ext_pmt_party_id

Line 1052: from iby_external_payees_all payee, iby_pmt_instr_uses_all uses

1048: l_cur_payee_rec l_payee_cur%ROWTYPE;
1049:
1050: cursor l_payee_assignment_cur is
1051: select uses.object_version_number
1052: from iby_external_payees_all payee, iby_pmt_instr_uses_all uses
1053: where payee.ext_payee_id = l_party_id
1054: and payee.org_id is null
1055: and payee.party_site_id is null
1056: and payee.supplier_site_id = p_vendor_site_id