APPS.POS_SBD_IBY_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1001: select org_id, party_site_id from ap_supplier_sites_all where

997: l_party_id number;
998: L_PAYEE_ASSIGNMENT_ID number;
999:
1000: cursor l_site_detail_cur is
1001: select org_id, party_site_id from ap_supplier_sites_all where
1002: vendor_site_id = p_vendor_site_id;
1003: l_party_site_id number;
1004: l_org_id number;
1005:

Line 1009: iby_ext_bank_accounts act, ap_supplier_sites_all pvsa

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
1013: and payee.org_id = pvsa.org_id