APPS.PAY_DK_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 22: ,per_time_periods ptp

18: greatest(min(asg.effective_start_date)
19: ,min(ptp.start_date))
20: from
21: per_all_assignments_f asg
22: ,per_time_periods ptp
23: where asg.assignment_id = p_assignment_id
24: and ptp.payroll_id = asg.payroll_id
25: and ptp.start_date <= asg.effective_end_date;
26:

Line 82: ,per_time_periods ptp

78: ,p_upload_date DATE
79: ) IS
80: SELECT ptp.start_date
81: FROM per_all_assignments_f ass
82: ,per_time_periods ptp
83: WHERE ass.assignment_id = p_assignment_id
84: AND ass.effective_start_date <= p_upload_date
85: AND ass.effective_end_date >= p_upload_date
86: AND ptp.payroll_id = ass.payroll_id