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_REPOSITORY_F

Line 724: FROM pqp_vehicle_repository_f pvr

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

Line 817: FROM PQP_VEHICLE_REPOSITORY_F

813: )RETURN NUMBER IS
814: --get the values for vehicleStatus and SharedVehicle
815: CURSOR c__veh_data_cursor IS
816: SELECT vehicle_status
817: FROM PQP_VEHICLE_REPOSITORY_F
818: WHERE vehicle_repository_id = p_rec.vehicle_repository_id
819: AND p_effective_date between effective_start_date and effective_end_date
820: AND business_group_id = p_rec.business_group_id ;
821:

Line 822: l_vehicle_status PQP_VEHICLE_REPOSITORY_F.vehicle_status%type;

818: WHERE vehicle_repository_id = p_rec.vehicle_repository_id
819: AND p_effective_date between effective_start_date and effective_end_date
820: AND business_group_id = p_rec.business_group_id ;
821:
822: l_vehicle_status PQP_VEHICLE_REPOSITORY_F.vehicle_status%type;
823: BEGIN
824: OPEN c__veh_data_cursor;
825: FETCH c__veh_data_cursor INTO l_vehicle_status;
826: CLOSE c__veh_data_cursor;

Line 849: FROM pqp_vehicle_repository_f pvr

845: l_exist VARCHAR2(1);
846: Begin
847: SELECT 'X'
848: INTO l_exist
849: FROM pqp_vehicle_repository_f pvr
850: WHERE pvr.vehicle_repository_id=p_rec.vehicle_repository_id
851: AND pvr.business_group_id=p_rec.business_group_id
852: AND p_effective_date BETWEEN pvr.effective_start_date
853: AND pvr.effective_end_date;

Line 914: FROM pqp_vehicle_repository_f pvr

910: --(primary/secondary)/(Essential/Casual) for assignment based current
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

Line 986: pqp_vehicle_repository_f pvr

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
990: AND pva.effective_end_date

Line 996: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;

992: AND pvr.effective_end_date ;
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:

Line 1184: pqp_vehicle_repository_f pvr

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
1188: AND pva.effective_end_date

Line 1193: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;

1189: AND p_effective_date BETWEEN pvr.effective_start_date
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;

Line 1231: FROM pqp_vehicle_repository_f pvr

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

Line 1300: ,pqp_vehicle_repository_f pvr

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
1304: AND pel.element_type_id=pet.element_type_id

Line 1387: FROM pqp_vehicle_repository_f pvr

1383: ,pvr.vehicle_status
1384: ,pvr.shared_vehicle
1385: ,pvr.initial_registration
1386: ,pvr.registration_number
1387: FROM pqp_vehicle_repository_f pvr
1388: WHERE pvr.vehicle_repository_id = p_rec.vehicle_repository_id
1389: AND pvr.business_group_id= p_rec.business_group_id
1390: AND p_effective_date BETWEEN
1391: pvr.effective_start_date AND

Line 1402: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;

1398: l_cmy_veh_alloc_count NUMBER;
1399: l_pri_veh_alloc_count NUMBER;
1400: l_message VARCHAR2(2500) ;
1401: l_max_conf_count VARCHAR2(10);
1402: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
1403: l_legislation_code varchar2(150);
1404: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1405: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;
1406: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;

Line 1404: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;

1400: l_message VARCHAR2(2500) ;
1401: l_max_conf_count VARCHAR2(10);
1402: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
1403: l_legislation_code varchar2(150);
1404: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1405: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;
1406: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1407: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1408: --

Line 1405: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;

1401: l_max_conf_count VARCHAR2(10);
1402: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
1403: l_legislation_code varchar2(150);
1404: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1405: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;
1406: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1407: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1408: --
1409:

Line 1406: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;

1402: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;
1403: l_legislation_code varchar2(150);
1404: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1405: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;
1406: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1407: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1408: --
1409:
1410: Begin

Line 1407: l_registration_number pqp_vehicle_repository_f.registration_number%type;

1403: l_legislation_code varchar2(150);
1404: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1405: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;
1406: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1407: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1408: --
1409:
1410: Begin
1411: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1717: FROM pqp_vehicle_repository_f pvr

1713: SELECT pvr.vehicle_ownership
1714: ,pvr.vehicle_status
1715: ,pvr.initial_registration
1716: ,pvr.registration_number
1717: FROM pqp_vehicle_repository_f pvr
1718: WHERE pvr.vehicle_repository_id = p_rec.vehicle_repository_id
1719: AND pvr.business_group_id= p_rec.business_group_id
1720: AND p_effective_date BETWEEN
1721: pvr.effective_start_date

Line 1729: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;

1725: l_proc varchar2(72) := g_package||'update_validate';
1726: l_validation_start_date date;
1727: l_validation_end_date date;
1728: l_return_status NUMBER ;
1729: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1730: l_return_count NUMBER;
1731: l_message VARCHAR2(2500) ;
1732: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
1733: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;

Line 1732: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;

1728: l_return_status NUMBER ;
1729: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1730: l_return_count NUMBER;
1731: l_message VARCHAR2(2500) ;
1732: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
1733: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1734: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1735:
1736:

Line 1733: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;

1729: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;
1730: l_return_count NUMBER;
1731: l_message VARCHAR2(2500) ;
1732: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
1733: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1734: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1735:
1736:
1737: --

Line 1734: l_registration_number pqp_vehicle_repository_f.registration_number%type;

1730: l_return_count NUMBER;
1731: l_message VARCHAR2(2500) ;
1732: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;
1733: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;
1734: l_registration_number pqp_vehicle_repository_f.registration_number%type;
1735:
1736:
1737: --
1738: Begin