APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_PARTY_SITES

Line 696: SELECT location_id FROM hz_party_sites

692: WHERE location_id = p_incident_location_id;
693:
694: -- Added for 11.5.10 Incident Location Type ER
695: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
696: SELECT location_id FROM hz_party_sites
697: WHERE party_site_id = p_party_site_id;
698:
699: CURSOR C_CONTRACT(l_contract_service_id NUMBER)is
700: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)

Line 1060: SELECT location_id FROM hz_party_sites

1056: WHERE location_id = p_incident_location_id;
1057:
1058: -- Added for 11.5.10 Incident Location Type ER
1059: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
1060: SELECT location_id FROM hz_party_sites
1061: WHERE party_site_id = p_party_site_id;
1062:
1063: CURSOR c_contract(l_contract_service_id NUMBER) IS
1064: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)