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 3400: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;

3396: l_effective_end_date DATE;
3397: l_person_id per_all_people_f.person_id%TYPE;
3398: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3399: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3400: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
3401: l_effective_date DATE;
3402: BEGIN
3403: l_person_id := hr_transaction_api.get_number_value (
3404: p_transaction_step_id => p_transaction_step_id,

Line 3519: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;

3515: l_vre_information17 pqp_vehicle_repository_f.vre_information17%TYPE;
3516: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3517: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3518: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3519: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;

Line 3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;

3516: l_vre_information18 pqp_vehicle_repository_f.vre_information18%TYPE;
3517: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3518: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3519: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;

Line 3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;

3517: l_vre_information19 pqp_vehicle_repository_f.vre_information19%TYPE;
3518: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3519: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;

Line 3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;

3518: l_vre_information20 pqp_vehicle_repository_f.vre_information20%TYPE;
3519: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;

Line 3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;

3519: l_across_assignments pqp_vehicle_allocations_f.across_assignments%TYPE;
3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;

Line 3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;

3520: l_usage_type pqp_vehicle_allocations_f.usage_type%TYPE;
3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;

Line 3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;

3521: l_default_vehicle pqp_vehicle_allocations_f.default_vehicle%TYPE;
3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;

Line 3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;

3522: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;

Line 3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;

3523: l_fuel_card_number pqp_vehicle_allocations_f.fuel_card_number%TYPE;
3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;

Line 3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;

3524: l_val_attribute_category pqp_vehicle_allocations_f.val_attribute_category%TYPE;
3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;

Line 3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;

3525: l_val_attribute1 pqp_vehicle_allocations_f.val_attribute1%TYPE;
3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;

Line 3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;

3526: l_val_attribute2 pqp_vehicle_allocations_f.val_attribute2%TYPE;
3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;

Line 3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;

3527: l_val_attribute3 pqp_vehicle_allocations_f.val_attribute3%TYPE;
3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;

Line 3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;

3528: l_val_attribute4 pqp_vehicle_allocations_f.val_attribute4%TYPE;
3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;

Line 3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;

3529: l_val_attribute5 pqp_vehicle_allocations_f.val_attribute5%TYPE;
3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;

Line 3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;

3530: l_val_attribute6 pqp_vehicle_allocations_f.val_attribute6%TYPE;
3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;

Line 3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;

3531: l_val_attribute7 pqp_vehicle_allocations_f.val_attribute7%TYPE;
3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;

Line 3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;

3532: l_val_attribute8 pqp_vehicle_allocations_f.val_attribute8%TYPE;
3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;

Line 3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;

3533: l_val_attribute9 pqp_vehicle_allocations_f.val_attribute9%TYPE;
3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;

Line 3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;

3534: l_val_attribute10 pqp_vehicle_allocations_f.val_attribute10%TYPE;
3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;

Line 3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;

3535: l_val_attribute11 pqp_vehicle_allocations_f.val_attribute11%TYPE;
3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;

Line 3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;

3536: l_val_attribute12 pqp_vehicle_allocations_f.val_attribute12%TYPE;
3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;

Line 3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;

3537: l_val_attribute13 pqp_vehicle_allocations_f.val_attribute13%TYPE;
3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;

Line 3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;

3538: l_val_attribute14 pqp_vehicle_allocations_f.val_attribute14%TYPE;
3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;

Line 3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;

3539: l_val_attribute15 pqp_vehicle_allocations_f.val_attribute15%TYPE;
3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;

Line 3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;

3540: l_val_attribute16 pqp_vehicle_allocations_f.val_attribute16%TYPE;
3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;

Line 3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;

3541: l_val_attribute17 pqp_vehicle_allocations_f.val_attribute17%TYPE;
3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;

Line 3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;

3542: l_val_attribute18 pqp_vehicle_allocations_f.val_attribute18%TYPE;
3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;

Line 3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;

3543: l_val_attribute19 pqp_vehicle_allocations_f.val_attribute19%TYPE;
3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;

Line 3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;

3544: l_val_attribute20 pqp_vehicle_allocations_f.val_attribute20%TYPE;
3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;

Line 3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;

3545: l_val_information_category pqp_vehicle_allocations_f.val_information_category%TYPE;
3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;

Line 3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;

3546: l_val_information1 pqp_vehicle_allocations_f.val_information1%TYPE;
3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;

Line 3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;

3547: l_val_information2 pqp_vehicle_allocations_f.val_information2%TYPE;
3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;

Line 3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;

3548: l_val_information3 pqp_vehicle_allocations_f.val_information3%TYPE;
3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;

Line 3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;

3549: l_val_information4 pqp_vehicle_allocations_f.val_information4%TYPE;
3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;

Line 3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;

3550: l_val_information5 pqp_vehicle_allocations_f.val_information5%TYPE;
3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;

Line 3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;

3551: l_val_information6 pqp_vehicle_allocations_f.val_information6%TYPE;
3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;

Line 3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;

3552: l_val_information7 pqp_vehicle_allocations_f.val_information7%TYPE;
3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;

Line 3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;

3553: l_val_information8 pqp_vehicle_allocations_f.val_information8%TYPE;
3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;

Line 3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;

3554: l_val_information9 pqp_vehicle_allocations_f.val_information9%TYPE;
3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;

Line 3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;

3555: l_val_information10 pqp_vehicle_allocations_f.val_information10%TYPE;
3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;

Line 3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;

3556: l_val_information11 pqp_vehicle_allocations_f.val_information11%TYPE;
3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;

Line 3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;

3557: l_val_information12 pqp_vehicle_allocations_f.val_information12%TYPE;
3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;

Line 3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;

3558: l_val_information13 pqp_vehicle_allocations_f.val_information13%TYPE;
3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3566: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;

Line 3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;

3559: l_val_information14 pqp_vehicle_allocations_f.val_information14%TYPE;
3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3566: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3567: l_object_version_number NUMBER;

Line 3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;

3560: l_val_information15 pqp_vehicle_allocations_f.val_information15%TYPE;
3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3566: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3567: l_object_version_number NUMBER;
3568: l_error_message VARCHAr2(80);

Line 3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;

3561: l_val_information16 pqp_vehicle_allocations_f.val_information16%TYPE;
3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3566: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3567: l_object_version_number NUMBER;
3568: l_error_message VARCHAr2(80);
3569: l_error_status VARCHAr2(30);

Line 3566: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;

3562: l_val_information17 pqp_vehicle_allocations_f.val_information17%TYPE;
3563: l_val_information18 pqp_vehicle_allocations_f.val_information18%TYPE;
3564: l_val_information19 pqp_vehicle_allocations_f.val_information19%TYPE;
3565: l_val_information20 pqp_vehicle_allocations_f.val_information20%TYPE;
3566: l_fuel_benefit pqp_vehicle_allocations_f.fuel_benefit%TYPE;
3567: l_object_version_number NUMBER;
3568: l_error_message VARCHAr2(80);
3569: l_error_status VARCHAr2(30);
3570: l_vehicle_allocation_id NUMBER;

Line 3598: ,pqp_vehicle_allocations_f pva

3594: CURSOR c_get_details IS
3595: SELECT pvr.vehicle_repository_id
3596: ,pva.vehicle_allocation_id
3597: FROM pqp_vehicle_repository_f pvr
3598: ,pqp_vehicle_allocations_f pva
3599: WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
3600: AND pva.assignment_id =l_assignment_id
3601: AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date
3602: AND pvr.effective_end_date

Line 4290: FROM pqp_vehicle_allocations_f pva

4286: )
4287: IS
4288: SELECT pva.object_version_number
4289: ,pva.vehicle_repository_id repository_id
4290: FROM pqp_vehicle_allocations_f pva
4291: WHERE pva.vehicle_allocation_id =cp_allocation_id
4292: AND pva.assignment_id =cp_assignment_id
4293: AND pva.business_group_id =cp_business_group_id
4294: AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date

Line 4304: FROM pqp_vehicle_allocations_f pva

4300: ,cp_effective_date DATE
4301: )
4302: IS
4303: SELECT COUNT(pva.vehicle_repository_id) usr_count
4304: FROM pqp_vehicle_allocations_f pva
4305: WHERE pva.vehicle_repository_id = cp_repository_id
4306: AND pva.business_group_id =cp_business_group_id
4307: AND pva.assignment_id = cp_assignment_id
4308: AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date