APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on HR_LOOKUPS

Line 336: ,hr_lookups lkp

332: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
333: ,hr_transaction_api.get_number_Value
334: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
335: FROM DUAL) Vehtrn
336: ,hr_lookups lkp
337: WHERE vehtrn.vehicle_type=lkp.lookup_code
338: AND lkp.lookup_type='PQP_VEHICLE_TYPE' ;
339:
340: RETURN csr;

Line 1254: FROM hr_lookups hrl

1250: AND paa.effective_end_date;
1251:
1252: CURSOR c_fiscal_uom IS
1253: SELECT hrl.lookup_code
1254: FROM hr_lookups hrl
1255: WHERE lookup_type = 'PQP_FISCAL_RATINGS_UOM'
1256: AND enabled_flag = 'Y';
1257:
1258: CURSOR c_get_repository_id (cp_registration_number VARCHAR2

Line 1279: l_lookup_code hr_lookups.lookup_code%TYPE;

1275: l_object_version_number NUMBER;
1276: l_user_info t_user_info;
1277: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
1278: l_get_repository_id c_get_repository_id%ROWTYPE;
1279: l_lookup_code hr_lookups.lookup_code%TYPE;
1280: l_leg_code pqp_configuration_values.legislation_code%TYPE;
1281: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1282: l_correction NUMBER;
1283: l_update NUMBER;