APPS.PAY_SE_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 42: FROM per_time_periods PTP

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