APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_PARTY_SITES

Line 518: SELECT location_id FROM hz_party_sites

514: FROM hz_locations
515: WHERE location_id = p_incident_location_id;
516:
517: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
518: SELECT location_id FROM hz_party_sites
519: WHERE party_site_id = p_party_site_id;
520:
521: CURSOR C_CONTRACT(l_contract_service_id number) IS
522: SELECT to_number(object1_id1), to_number(object1_id2)

Line 940: SELECT location_id FROM hz_party_sites

936: FROM hz_locations
937: WHERE location_id = p_incident_location_id;
938:
939: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
940: SELECT location_id FROM hz_party_sites
941: WHERE party_site_id = p_party_site_id;
942:
943: CURSOR c_contract(l_contract_service_id NUMBER)IS
944: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)