APPS.PER_AU_ASG_LEG_HOOK dependencies on PER_TIME_PERIODS

Line 23: FROM per_time_periods ptp

19: AND paaf.assignment_id = paa.assignment_id
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 >= (SELECT ptp.start_date
23: FROM per_time_periods ptp
24: WHERE ptp.payroll_id = ppa.payroll_id
25: AND c_effective_date BETWEEN ptp.start_date AND ptp.end_date)
26: and ppa.action_type IN ('Q','R','B','I','V');
27: