DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 553: FROM pqp_vehicle_repository_f a , pqp_vehicle_allocations_f b

549: + nvl(a.accessory_value_at_startdate,0)
550: + nvl(a.accessory_value_added_later ,0)
551: , a.engine_capacity_in_cc
552: , a.vehicle_type
553: FROM pqp_vehicle_repository_f a , pqp_vehicle_allocations_f b
554: WHERE a.VEHICLE_REPOSITORY_ID = b.VEHICLE_REPOSITORY_ID
555: AND p_effective_date between b.effective_start_date
556: AND b.effective_end_date
557: AND p_effective_date between a.effective_start_date