DBA Data[Home] [Help]

APPS.PAY_IE_BIK dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 559: pqp_vehicle_allocations_f pva

555: SELECT
556: fiscal_ratings
557: FROM
558: pqp_vehicle_repository_f pvr,
559: pqp_vehicle_allocations_f pva
560: WHERE pvr.vehicle_repository_id = pva.vehicle_repository_id
561: AND pva.vehicle_allocation_id = c_allocation_id
562: -- AND to_char(pvr.EFFECTIVE_END_DATE,'DDMMYYYY')='31124712';
563: AND pvr.EFFECTIVE_END_DATE =

Line 568: pqp_vehicle_allocations_f pva

564: (SELECT
565: MAX(pvr.EFFECTIVE_END_DATE)
566: FROM
567: pqp_vehicle_repository_f pvr,
568: pqp_vehicle_allocations_f pva
569: WHERE pvr.vehicle_repository_id = pva.vehicle_repository_id
570: AND pva.vehicle_allocation_id = c_allocation_id);
571:
572: rating number;