APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_PARTY_SITES

Line 506: SELECT location_id FROM hz_party_sites

502: FROM hz_locations
503: WHERE location_id = p_incident_location_id;
504:
505: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
506: SELECT location_id FROM hz_party_sites
507: WHERE party_site_id = p_party_site_id;
508:
509: CURSOR C_CONTRACT(l_contract_service_id number) IS
510: SELECT to_number(object1_id1), to_number(object1_id2)

Line 833: SELECT location_id FROM hz_party_sites

829: FROM hz_locations
830: WHERE location_id = p_incident_location_id;
831:
832: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
833: SELECT location_id FROM hz_party_sites
834: WHERE party_site_id = p_party_site_id;
835:
836: CURSOR c_contract(l_contract_service_id NUMBER)IS
837: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)