APPS.PER_AU_ASG_LEG_HOOK dependencies on PER_TIME_PERIODS

Line 24: FROM per_time_periods ptp

20: AND paaf.business_group_id = ppa.business_group_id
21: AND ppa.payroll_action_id = paa.payroll_action_id
22: AND ppa.effective_date >= c_effective_date
23: AND ppa.effective_date >= (SELECT ptp.start_date
24: FROM per_time_periods ptp
25: WHERE ptp.payroll_id = ppa.payroll_id
26: AND c_effective_date BETWEEN ptp.start_date AND ptp.end_date)
27: and ppa.action_type IN ('Q','R','B','I','V');
28: