eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VAL_BUS dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 31: , pqp_vehicle_allocations_f val

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pqp_vehicle_allocations_f val
32: where val.vehicle_allocation_id = p_vehicle_allocation_id
33: and pbg.business_group_id = val.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pqp_vehicle_allocations_f val

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pqp_vehicle_allocations_f val
102: where val.vehicle_allocation_id = p_vehicle_allocation_id
103: and pbg.business_group_id = val.business_group_id;
104: --
105: -- Declare local variables

Line 725: ,pqp_vehicle_allocations_f pva

721: --used to get the allocation count fr future and current date track
722: CURSOR c_alloc_count_cursor IS
723: SELECT COUNT(pva.vehicle_allocation_id)
724: FROM pqp_vehicle_repository_f pvr
725: ,pqp_vehicle_allocations_f pva
726: WHERE pvr.vehicle_repository_id = pva.vehicle_repository_id
727: AND pvr.business_group_id = pva.business_group_id
728: AND pvr.vehicle_ownership = p_vehicle_ownership
729: AND pva.assignment_id = p_rec.assignment_id

Line 915: ,pqp_vehicle_allocations_f pva

911: --and future date tracks
912: CURSOR c_alloc_count_cursor IS
913: SELECT COUNT(pva.vehicle_allocation_id)
914: FROM pqp_vehicle_repository_f pvr
915: ,pqp_vehicle_allocations_f pva
916: WHERE pvr.vehicle_repository_id = pva.vehicle_repository_id
917: AND pvr.business_group_id = pva.business_group_id
918: AND pvr.vehicle_ownership = p_vehicle_ownership
919: AND pva.usage_type = p_rec.usage_type

Line 985: FROM pqp_vehicle_allocations_f pva,

981: AND peev2.screen_entry_value =cp_registration_number;
982:
983: CURSOR c_claim_veh_det_cursor IS
984: SELECT pvr.registration_number, pva.assignment_id
985: FROM pqp_vehicle_allocations_f pva,
986: pqp_vehicle_repository_f pvr
987: WHERE pva.vehicle_allocation_id= p_rec.vehicle_allocation_id
988: AND pva.vehicle_repository_id =pvr.vehicle_repository_id
989: AND p_effective_date BETWEEN pva.effective_start_date

Line 997: l_assignment_id pqp_vehicle_allocations_f.assignment_id%TYPE;

993:
994:
995: l_alloc_count NUMBER ;
996: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
997: l_assignment_id pqp_vehicle_allocations_f.assignment_id%TYPE;
998:
999: BEGIN
1000:
1001: --Curosr for getting the regnumber and assignment

Line 1054: FROM pqp_vehicle_allocations_f pva,

1050: --vehicle setting at configuration
1051:
1052: CURSOR c_person_alloc_count_cursor IS
1053: SELECT COUNT(pva.vehicle_allocation_id)
1054: FROM pqp_vehicle_allocations_f pva,
1055: per_all_assignments_f paa
1056: WHERE paa.assignment_id = pva.assignment_id
1057: AND pva.assignment_id NOT IN ( SELECT assignment_id
1058: FROM per_all_assignments_f

Line 1124: FROM pqp_vehicle_allocations_f pva

1120: ) RETURN NUMBER IS
1121:
1122: CURSOR c_alloc_count_cursor IS
1123: SELECT COUNT(pva.vehicle_allocation_id)
1124: FROM pqp_vehicle_allocations_f pva
1125: WHERE pva.assignment_id = p_rec.assignment_id
1126: AND pva.vehicle_repository_id = p_rec.vehicle_repository_id
1127: AND pva.business_group_id = p_rec.business_group_id
1128: AND (p_effective_date

Line 1183: FROM pqp_vehicle_allocations_f pva,

1179:
1180:
1181: CURSOR c_clm_veh_det_cursor IS
1182: SELECT pvr.registration_number, pva.assignment_id
1183: FROM pqp_vehicle_allocations_f pva,
1184: pqp_vehicle_repository_f pvr
1185: WHERE pva.vehicle_allocation_id= p_rec.vehicle_allocation_id
1186: AND pva.vehicle_repository_id =pvr.vehicle_repository_id
1187: AND p_effective_date BETWEEN pva.effective_start_date

Line 1194: l_assignment_id pqp_vehicle_allocations_f.assignment_id%TYPE;

1190: AND pvr.effective_end_date ;
1191:
1192: l_alloc_count NUMBER ;
1193: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;
1194: l_assignment_id pqp_vehicle_allocations_f.assignment_id%TYPE;
1195:
1196: BEGIN
1197: OPEN c_clm_veh_det_cursor;
1198: FETCH c_clm_veh_det_cursor INTO l_registration_number,l_assignment_id;

Line 1232: ,pqp_vehicle_allocations_f pva

1228: --Used to get the allocations count for private vehicle default count
1229: CURSOR c_alloc_count_cursor IS
1230: SELECT COUNT(pva.vehicle_allocation_id)
1231: FROM pqp_vehicle_repository_f pvr
1232: ,pqp_vehicle_allocations_f pva
1233: WHERE pvr.vehicle_repository_id = pva.vehicle_repository_id
1234: AND pvr.business_group_id = pva.business_group_id
1235: AND pvr.vehicle_ownership = p_vehicle_ownership
1236: AND pva.default_vehicle = 'Y'

Line 1299: , pqp_vehicle_allocations_f pva

1295: ,pay_element_links_f pel
1296: ,pay_element_types_f pet
1297: ,pay_input_values_f piv
1298: , pay_element_entry_values_f peev
1299: , pqp_vehicle_allocations_f pva
1300: ,pqp_vehicle_repository_f pvr
1301: WHERE pee.ASSIGNMENT_ID=p_assignment_id
1302: AND pel.business_group_id=p_business_group_id
1303: AND pee.element_link_id=pel.element_link_id