APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 861: from ap_supplier_contacts ASCS

857:
858: CURSOR l_cur IS
859: select ASCS.vendor_site_id, ASCS.relationship_id, ASCS.org_contact_id,
860: ASCS.rel_party_id, ASCS.party_site_id, ASCS.vendor_contact_id
861: from ap_supplier_contacts ASCS
862: where (ASCS.inactive_date is null OR ASCS.inactive_date > sysdate)
863: AND ASCS.org_party_site_id = p_org_party_site_id
864: AND ASCS.per_party_id = p_contact_party_id;
865:

Line 936: /* updating address details to ap_supplier_contacts

932:
933: END unassign_address_to_contact;
934:
935: -- code added for bug 8237063
936: /* updating address details to ap_supplier_contacts
937: when only the contact related data is changed and the
938: address assignments are not added or deleted */
939: PROCEDURE update_address_to_contact
940: (p_contact_party_id IN NUMBER,

Line 952: from ap_supplier_contacts ASCS

948:
949: CURSOR l_cur IS
950: select ASCS.vendor_site_id, ASCS.relationship_id, ASCS.org_contact_id,
951: ASCS.rel_party_id, ASCS.party_site_id, ASCS.vendor_contact_id, ASCS.inactive_date
952: from ap_supplier_contacts ASCS
953: where (ASCS.inactive_date is null OR ASCS.inactive_date > sysdate)
954: AND ASCS.org_party_site_id = p_org_party_site_id
955: AND ASCS.per_party_id = p_contact_party_id;
956:

Line 1055: FROM ap_supplier_contacts

1051: IS
1052:
1053: CURSOR l_cur IS
1054: SELECT 1
1055: FROM ap_supplier_contacts
1056: WHERE org_party_site_id = p_org_party_site_id
1057: AND per_party_id = p_contact_party_id
1058: AND (inactive_date is null OR inactive_date >= sysdate)
1059: AND rownum = 1;