DBA Data[Home] [Help]

APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 234: -- Cursor to retrieve end_dates from per_time_periods

230: c_effective_end_date between pef2.effective_start_date
231: and pef2.effective_end_date
232: );
233:
234: -- Cursor to retrieve end_dates from per_time_periods
235: Cursor csr_get_end_date
236: (c_assignment_id number
237: ,c_effective_start_date date
238: ,c_effective_end_date date) is

Line 240: from per_time_periods ptp

236: (c_assignment_id number
237: ,c_effective_start_date date
238: ,c_effective_end_date date) is
239: select distinct(ptp.end_date) end_date
240: from per_time_periods ptp
241: ,pay_payroll_actions ppa
242: ,pay_assignment_actions paa
243: where ptp.time_period_id = ppa.time_period_id
244: and ppa.payroll_action_id = paa.payroll_action_id