APPS.CLN_RN_UTILS dependencies on HR_LOCATIONS

Line 350: FROM hr_locations_all loc, hr_all_organization_units_vl org

346: , x_email
347: , x_telephone
348: , x_fax
349: , x_ece_location_code
350: FROM hr_locations_all loc, hr_all_organization_units_vl org
351: WHERE org.location_id = loc.location_id
352: AND org.organization_id = p_org_id;
353: IF (l_Debug_Level <= 1) THEN
354: cln_debug_pub.Add('Result From the Query........', 1);

Line 434: FROM HR_LOCATIONS

430: AND hp.PRIMARY_PHONE_CONTACT_PT_ID = hcp.CONTACT_POINT_ID;
431: ELSIF (l_party_type = 'I') THEN
432: SELECT location_code, telephone_number_1, ece_tp_location_code
433: INTO x_name, x_telephone, x_ece_location_code
434: FROM HR_LOCATIONS
435: WHERE location_id = l_party_id;
436: ELSIF (l_party_type = 'C') or (l_party_type = 'CARRIER') THEN
437: SELECT hz.party_name
438: INTO x_name