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_SS_VEHICLE_TRANSACTIONS dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 156: FROM pqp_vehicle_allocations_f pva

152: )
153: IS
154: SELECT pva.object_version_number
155: ,pva.vehicle_repository_id repository_id
156: FROM pqp_vehicle_allocations_f pva
157: WHERE pva.vehicle_allocation_id =cp_allocation_id
158: AND pva.assignment_id =cp_assignment_id
159: AND pva.business_group_id =cp_business_group_id
160: AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date

Line 170: FROM pqp_vehicle_allocations_f pva

166: ,cp_effective_date DATE
167: )
168: IS
169: SELECT COUNT(pva.vehicle_repository_id) usr_count
170: FROM pqp_vehicle_allocations_f pva
171: WHERE pva.vehicle_repository_id = cp_repository_id
172: AND pva.business_group_id =cp_business_group_id
173: AND pva.assignment_id = cp_assignment_id
174: AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date

Line 725: allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE

721: lc_object_version_number NUMBER;
722: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
723: TYPE r_assignment_rec IS RECORD
724: (assignment_id per_all_assignments_f.assignment_id%TYPE,
725: allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE
726: ,user_type VARCHAR2(10));
727:
728: TYPE t_assignment_tab IS TABLE OF r_assignment_rec
729: INDEX BY BINARY_INTEGER;

Line 743: FROM pqp_vehicle_allocations_f pva

739: )
740: IS
741: SELECT pva.assignment_id ,
742: pva.vehicle_allocation_id allocation_id
743: FROM pqp_vehicle_allocations_f pva
744: ,pqp_vehicle_repository_f pvr
745: WHERE pvr.registration_number = cp_registration_number
746: AND pvr.business_group_id = cp_business_group_id
747: AND pvr.business_group_id=pva.business_group_id

Line 763: FROM pqp_vehicle_allocations_f pva

759: ,cp_effective_date DATE
760: )
761: IS
762: SELECT pva.object_version_number
763: FROM pqp_vehicle_allocations_f pva
764: WHERE pva.vehicle_allocation_id =cp_vehicle_allocation_id
765: AND pva.assignment_id = cp_assignment_id
766: AND pva.business_group_id = cp_business_group_id
767: AND cp_effective_date BETWEEN pva.effective_start_date

Line 797: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;

793: l_update_change_insert NUMBER;
794: l_effective_start_date DATE;
795: l_effective_end_date DATE;
796: l_vehicle_repository_id pqp_vehicle_repository_f.vehicle_repository_id%TYPE;
797: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
798: l_cnt NUMBER :=0;
799:
800:
801: BEGIN

Line 1010: ,p_base_table_name =>'PQP_VEHICLE_ALLOCATIONS_F'

1006: CLOSE c_get_object_version_number;
1007: ---get_date track mode
1008: pqp_get_date_mode.find_dt_upd_modes
1009: (p_effective_date =>p_effective_date
1010: ,p_base_table_name =>'PQP_VEHICLE_ALLOCATIONS_F'
1011: ,p_base_key_column =>'VEHICLE_ALLOCATION_ID'
1012: ,p_base_key_value =>l_user_info(i).allocation_id
1013: ,p_correction =>l_correction
1014: ,p_update =>l_update

Line 1277: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;

1273: l_vehicle_repository_id pqp_vehicle_repository_f.vehicle_repository_id%TYPE;
1274: l_object_version_number1 NUMBER;
1275: l_object_version_number NUMBER;
1276: l_user_info t_user_info;
1277: l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
1278: l_get_repository_id c_get_repository_id%ROWTYPE;
1279: l_lookup_code hr_lookups.lookup_code%TYPE;
1280: l_leg_code pqp_configuration_values.legislation_code%TYPE;
1281: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 1458: FROM pqp_vehicle_allocations_f pvf

1454: /* Added below Code Snippet to check for Duplicate rows for same assignment as a part of bug#12937050.*/
1455: BEGIN
1456: SELECT COUNT(1)
1457: INTO l_count
1458: FROM pqp_vehicle_allocations_f pvf
1459: WHERE pvf.vehicle_repository_id = l_vehicle_repository_id
1460: AND pvf.assignment_id = l_user_info(i).assignment_id;
1461: END;
1462: IF l_count = 0 -- Condition to check whether vehicle for this assignment already exists or not.

Line 3425: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;

3421: l_effective_end_date DATE;
3422: l_person_id per_all_people_f.person_id%TYPE;
3423: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3424: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3425: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
3426: l_effective_date DATE;
3427: BEGIN
3428: l_person_id := hr_transaction_api.get_number_value (
3429: p_transaction_step_id => p_transaction_step_id,

Line 3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;

3540: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;

Line 3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;

3541: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;

Line 3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;

3542: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;

Line 3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;

3543: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;

Line 3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;

3544: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;

Line 3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;

3545: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;

Line 3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;

3546: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;

Line 3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;

3547: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;

Line 3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;

3548: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;

Line 3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;

3549: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;

Line 3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;

3550: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;

Line 3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;

3551: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;

Line 3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;

3552: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;

Line 3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;

3553: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;

Line 3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;

3554: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;

Line 3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;

3555: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;

Line 3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;

3556: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;

Line 3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;

3557: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;

Line 3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;

3558: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;

Line 3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;

3559: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;

Line 3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;

3560: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;

Line 3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;

3561: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;

Line 3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;

3562: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;

Line 3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;

3563: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;

Line 3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;

3564: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;

Line 3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;

3565: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;

Line 3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;

3566: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;

Line 3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;

3567: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;

Line 3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;

3568: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;

Line 3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;

3569: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;

Line 3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;

3570: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;

Line 3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;

3571: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;

Line 3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;

3572: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;

Line 3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;

3573: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;

Line 3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;

3574: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;

Line 3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;

3575: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;

Line 3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;

3576: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;

Line 3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;

3577: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;

Line 3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;

3578: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;

Line 3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;

3579: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;

Line 3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;

3580: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;

Line 3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;

3581: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;

Line 3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;

3582: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;

Line 3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;

3583: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3591: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;

Line 3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;

3584: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3591: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3592: l_object_version_number NUMBER;

Line 3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;

3585: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3591: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3592: l_object_version_number NUMBER;
3593: l_error_message VARCHAr2(80);

Line 3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;

3586: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3591: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3592: l_object_version_number NUMBER;
3593: l_error_message VARCHAr2(80);
3594: l_error_status VARCHAr2(30);

Line 3591: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;

3587: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3588: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3589: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3590: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3591: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3592: l_object_version_number NUMBER;
3593: l_error_message VARCHAr2(80);
3594: l_error_status VARCHAr2(30);
3595: l_vehicle_allocation_id NUMBER;

Line 3623: ,pqp_vehicle_allocations_f pva

3619: CURSOR c_get_details IS
3620: SELECT pvr.vehicle_repository_id
3621: ,pva.vehicle_allocation_id
3622: FROM pqp_vehicle_repository_f pvr
3623: ,pqp_vehicle_allocations_f pva
3624: WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
3625: AND pva.assignment_id =l_assignment_id
3626: AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date
3627: AND pvr.effective_end_date

Line 4315: FROM pqp_vehicle_allocations_f pva

4311: )
4312: IS
4313: SELECT pva.object_version_number
4314: ,pva.vehicle_repository_id repository_id
4315: FROM pqp_vehicle_allocations_f pva
4316: WHERE pva.vehicle_allocation_id =cp_allocation_id
4317: AND pva.assignment_id =cp_assignment_id
4318: AND pva.business_group_id =cp_business_group_id
4319: AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date

Line 4329: FROM pqp_vehicle_allocations_f pva

4325: ,cp_effective_date DATE
4326: )
4327: IS
4328: SELECT COUNT(pva.vehicle_repository_id) usr_count
4329: FROM pqp_vehicle_allocations_f pva
4330: WHERE pva.vehicle_repository_id = cp_repository_id
4331: AND pva.business_group_id =cp_business_group_id
4332: AND pva.assignment_id = cp_assignment_id
4333: AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date