APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_PARTY_SITES

Line 685: SELECT location_id FROM hz_party_sites

681: WHERE location_id = p_incident_location_id;
682:
683: -- Added for 11.5.10 Incident Location Type ER
684: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
685: SELECT location_id FROM hz_party_sites
686: WHERE party_site_id = p_party_site_id;
687:
688: CURSOR C_CONTRACT(l_contract_service_id NUMBER)is
689: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)

Line 1004: SELECT location_id FROM hz_party_sites

1000: WHERE location_id = p_incident_location_id;
1001:
1002: -- Added for 11.5.10 Incident Location Type ER
1003: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
1004: SELECT location_id FROM hz_party_sites
1005: WHERE party_site_id = p_party_site_id;
1006:
1007: CURSOR c_contract(l_contract_service_id NUMBER) IS
1008: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)