DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_ASSIGNMENTS_F

Line 97: per_assignments_f asg

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;
101: