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 1123: FROM pqp_vehicle_allocations_f pva

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

Line 1181: FROM pqp_vehicle_allocations_f pva,

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

Line 1192: l_assignment_id pqp_vehicle_allocations_f.assignment_id%TYPE;

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

Line 1230: ,pqp_vehicle_allocations_f pva

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

Line 1297: , pqp_vehicle_allocations_f pva

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