APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_PERIODS_OF_SERVICE
Line 96: from per_periods_of_service pds,
92:
93: cursor csr_get_emp_dates
94: is
95: select pds.DATE_START, pds.ACTUAL_TERMINATION_DATE 96: from per_periods_of_service pds, 97: per_assignments_f asg
98: where asg.assignment_id = p_assignment_id
99: and p_effective_date between asg.effective_start_date and asg.effective_end_date
100: and pds.period_of_service_id = asg.period_of_service_id;