DBA Data[Home] [Help]

APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 777: from ap_supplier_contacts ASCS

773:
774: CURSOR l_cur IS
775: select ASCS.vendor_site_id, ASCS.relationship_id, ASCS.org_contact_id,
776: ASCS.rel_party_id, ASCS.party_site_id, ASCS.vendor_contact_id
777: from ap_supplier_contacts ASCS
778: where (ASCS.inactive_date is null OR ASCS.inactive_date > sysdate)
779: AND ASCS.org_party_site_id = p_org_party_site_id
780: AND ASCS.per_party_id = p_contact_party_id;
781:

Line 879: FROM ap_supplier_contacts

875: IS
876:
877: CURSOR l_cur IS
878: SELECT 1
879: FROM ap_supplier_contacts
880: WHERE org_party_site_id = p_org_party_site_id
881: AND per_party_id = p_contact_party_id
882: AND (inactive_date is null OR inactive_date >= sysdate)
883: AND rownum = 1;