APPS.PAY_CN_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 91: FROM per_time_periods PTP

87: CURSOR csr_period_start( p_assignment_id NUMBER
88: , p_upload_date DATE
89: ) IS
90: SELECT NVL(PTP.start_date, END_OF_TIME)
91: FROM per_time_periods PTP
92: ,per_assignments_f ASS
93: WHERE ASS.assignment_id = p_assignment_id
94: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
95: AND PTP.payroll_id = ASS.payroll_id