APPS.PQP_PL_VEHICLE_ALLOCATIONS dependencies on PER_TIME_PERIODS

Line 182: FROM per_time_periods ptp,

178:
179:
180: cursor csr_pay_period(p_assignment_id number) is
181: SELECT max(ptp.end_date)
182: FROM per_time_periods ptp,
183: per_all_assignments_f paa
184: where ptp.payroll_id = paa.payroll_id and
185: paa.assignment_id = p_assignment_id;
186:

Line 189: l_period_end_date per_time_periods.end_date%type;

185: paa.assignment_id = p_assignment_id;
186:
187: l_element_entry_id pay_element_entries_f.element_entry_id%type;
188: l_assignment_id per_all_assignments_f.assignment_id%type;
189: l_period_end_date per_time_periods.end_date%type;
190: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
191:
192: l_effective_start_date date;
193: l_effective_end_date date;