DBA Data[Home] [Help]

APPS.POS_SBD_IBY_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1019: select org_id, party_site_id from ap_supplier_sites_all where

1015: l_party_id number;
1016: L_PAYEE_ASSIGNMENT_ID number;
1017:
1018: cursor l_site_detail_cur is
1019: select org_id, party_site_id from ap_supplier_sites_all where
1020: vendor_site_id = p_vendor_site_id;
1021: l_party_site_id number;
1022: l_org_id number;
1023:

Line 1027: iby_ext_bank_accounts act, ap_supplier_sites_all pvsa

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