APPS.PAY_IN_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 46: FROM per_time_periods PTP

42: CURSOR csr_period_start( p_assignment_id NUMBER
43: , p_upload_date DATE
44: ) IS
45: SELECT NVL(PTP.start_date, END_OF_TIME)
46: FROM per_time_periods PTP
47: ,per_assignments_f ASS
48: WHERE ASS.assignment_id = p_assignment_id
49: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
50: AND PTP.payroll_id = ASS.payroll_id