DBA Data[Home] [Help]

APPS.PER_IE_VEHICLE_ALLOC_RULES dependencies on PER_TIME_PERIODS

Line 66: FROM per_time_periods ptp,

62: group by pee.element_entry_id;
63:
64: CURSOR csr_pay_period(p_max_effective_date in DATE,p_max_date_earned in DATE) IS -- 5872123
65: SELECT min(ptp.end_date)
66: FROM per_time_periods ptp,
67: per_all_assignments_f paa,
68: pqp_vehicle_allocations_f pva
69: WHERE ptp.payroll_id = paa.payroll_id
70: AND paa.assignment_id = pva.assignment_id