DBA Data[Home] [Help]

APPS.PAY_IE_BIK dependencies on PQP_VEHICLE_REPOSITORY_F

Line 558: pqp_vehicle_repository_f pvr,

554: cursor fiscal_rating(c_allocation_id in number) is
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';

Line 567: pqp_vehicle_repository_f pvr,

563: AND pvr.EFFECTIVE_END_DATE =
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: