APPS.PQP_VEHICLE_REPOSITORY_MAPPING dependencies on PQP_VEHICLE_REPOSITORY_F

Line 10: l_vehicle_repository_id PQP_VEHICLE_REPOSITORY_F.vehicle_repository_id%TYPE;

6: FUNCTION get_vehicle_repository_id
7: ( p_vehicle_repository_user_key IN VARCHAR2)
8: RETURN NUMBER IS
9:
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

Line 39: l_vehicle_repository_ovn PQP_VEHICLE_REPOSITORY_F.object_version_number%TYPE;

35: FUNCTION get_vehicle_repository_ovn
36: ( p_vehicle_repository_user_key IN VARCHAR2)
37: RETURN NUMBER IS
38:
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

Line 42: FROM pqp_vehicle_repository_f pvd,

38:
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