DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 4831: FROM per_time_periods ptp,

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