APPS.M4U_CLN_PKG dependencies on HR_LOCATIONS_ALL

Line 1020: l_progress := 'Query for hr_locations_all based on location_code';

1016: l_country := 'US';
1017: -----------------------------------------------------------------------------
1018: -- Query HR Locations
1019: -- Check if record exists. Create Locations if it does not else Update Location value
1020: l_progress := 'Query for hr_locations_all based on location_code';
1021: BEGIN
1022: m4u_dmd_utils.log('Query hr_locations_all',1);
1023: SELECT location_id, object_version_number
1024: INTO l_location_id, l_obj_ver_num

Line 1022: m4u_dmd_utils.log('Query hr_locations_all',1);

1018: -- Query HR Locations
1019: -- Check if record exists. Create Locations if it does not else Update Location value
1020: l_progress := 'Query for hr_locations_all based on location_code';
1021: BEGIN
1022: m4u_dmd_utils.log('Query hr_locations_all',1);
1023: SELECT location_id, object_version_number
1024: INTO l_location_id, l_obj_ver_num
1025: FROM hr_locations_all
1026: WHERE location_code = l_location_code

Line 1025: FROM hr_locations_all

1021: BEGIN
1022: m4u_dmd_utils.log('Query hr_locations_all',1);
1023: SELECT location_id, object_version_number
1024: INTO l_location_id, l_obj_ver_num
1025: FROM hr_locations_all
1026: WHERE location_code = l_location_code
1027: AND ROWNUM < 2;
1028: l_record_found := TRUE;
1029:

Line 1187: FROM hr_locations_all h,

1183: BEGIN
1184: /* Package initialization. */
1185: SELECT to_char(e.party_id), to_char(e.party_site_id)
1186: INTO g_party_id, g_party_site_id
1187: FROM hr_locations_all h,
1188: ecx_tp_headers e
1189: WHERE h.location_id = e.party_id
1190: AND e.party_type = m4u_cln_pkg.c_party_type
1191: AND h.location_code = m4u_cln_pkg.c_party_site;