DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 4832: FROM per_time_periods ptp,

4828: c_effective_date DATE
4829: )
4830: IS
4831: SELECT DISTINCT (ptp.end_date) end_date
4832: FROM per_time_periods ptp,
4833: pay_payroll_actions ppa,
4834: pay_assignment_actions paa
4835: WHERE ptp.time_period_id = ppa.time_period_id
4836: AND ppa.effective_date BETWEEN ptp.start_date