APPS.PQP_VEHICLE_REPOSITORY_MAPPING dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 14: FROM hr_pump_batch_line_user_keys

10: l_vehicle_repository_id PQP_VEHICLE_REPOSITORY_F.vehicle_repository_id%TYPE;
11:
12: CURSOR veh_cur IS
13: SELECT unique_key_id
14: FROM hr_pump_batch_line_user_keys
15: WHERE user_key_value = p_vehicle_repository_user_key;
16: BEGIN
17: OPEN veh_cur;
18: FETCH veh_cur INTO l_vehicle_repository_id;

Line 43: hr_pump_batch_line_user_keys key

39: l_vehicle_repository_ovn PQP_VEHICLE_REPOSITORY_F.object_version_number%TYPE;
40: CURSOR ovn_cur(p_user_key_value IN VARCHAR2) IS
41: SELECT object_version_number
42: FROM pqp_vehicle_repository_f pvd,
43: hr_pump_batch_line_user_keys key
44: WHERE key.user_key_value = p_user_key_value
45: AND pvd.vehicle_repository_id = key.unique_key_id ;
46: BEGIN
47: OPEN ovn_cur(p_vehicle_repository_user_key);