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 1182: pqp_vehicle_repository_f pvr

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

Line 1191: l_registration_number pqp_vehicle_repository_f.registration_number%TYPE;

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

Line 1229: FROM pqp_vehicle_repository_f pvr

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

Line 1298: ,pqp_vehicle_repository_f pvr

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

Line 1385: FROM pqp_vehicle_repository_f pvr

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

Line 1400: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%type;

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

Line 1402: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;

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

Line 1403: l_shared_vehicle pqp_vehicle_repository_f.shared_vehicle%type;

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

Line 1404: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;

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

Line 1405: l_registration_number pqp_vehicle_repository_f.registration_number%type;

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

Line 1715: FROM pqp_vehicle_repository_f pvr

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

Line 1727: l_vehicle_status pqp_vehicle_repository_f.vehicle_status%type;

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

Line 1730: l_vehicle_ownership pqp_vehicle_repository_f.vehicle_ownership%TYPE;

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

Line 1731: l_initial_registration pqp_vehicle_repository_f.initial_registration%type;

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

Line 1732: l_registration_number pqp_vehicle_repository_f.registration_number%type;

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