DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 509: FROM pqp_vehicle_repository_f a , pqp_vehicle_allocations_f b

505: + nvl(a.accessory_value_at_startdate,0)
506: + nvl(a.accessory_value_added_later ,0)
507: , a.engine_capacity_in_cc
508: , a.vehicle_type
509: FROM pqp_vehicle_repository_f a , pqp_vehicle_allocations_f b
510: WHERE a.VEHICLE_REPOSITORY_ID = b.VEHICLE_REPOSITORY_ID
511: AND p_effective_date between b.effective_start_date
512: AND b.effective_end_date
513: AND p_effective_date between a.effective_start_date