APPS.CSE_ASSET_CREATION_PKG dependencies on HZ_LOCATIONS

Line 523: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN

519: x_return_status := fnd_api.g_ret_sts_success;
520:
521: IF p_location_type_code = 'INVENTORY' THEN
522: l_location_table := 'HR_LOCATIONS';
523: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
524: BEGIN
525: SELECT 'Y' INTO l_hz_or_hr
526: FROM hz_locations
527: WHERE location_id = p_location_id;

Line 526: FROM hz_locations

522: l_location_table := 'HR_LOCATIONS';
523: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
524: BEGIN
525: SELECT 'Y' INTO l_hz_or_hr
526: FROM hz_locations
527: WHERE location_id = p_location_id;
528: l_location_table := 'HZ_LOCATIONS';
529: EXCEPTION
530: WHEN no_data_found THEN

Line 528: l_location_table := 'HZ_LOCATIONS';

524: BEGIN
525: SELECT 'Y' INTO l_hz_or_hr
526: FROM hz_locations
527: WHERE location_id = p_location_id;
528: l_location_table := 'HZ_LOCATIONS';
529: EXCEPTION
530: WHEN no_data_found THEN
531: l_location_table := 'HR_LOCATIONS';
532: END;

Line 2254: l_location_type_code := 'HZ_LOCATIONS';

2250: END IF;
2251:
2252: ELSIF csi_txn_rec.transaction_type_id IN (132, 133, 105) THEN
2253:
2254: l_location_type_code := 'HZ_LOCATIONS';
2255:
2256: IF csi_txn_rec.transaction_type_id = 105 THEN
2257:
2258: SELECT deliver_to_location_id