APPS.PER_US_DEL_TAX_LEG_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 13: from per_all_assignments_f PAA,per_periods_of_service PPS

9: --
10: cursor csr_assignment_id(p_person_id NUMBER,p_effective_date DATE)
11: is
12: select assignment_id
13: from per_all_assignments_f PAA,per_periods_of_service PPS
14: where PAA.person_id=p_person_id
15: and PAA.period_of_service_id=PPS.period_of_service_id
16: and p_effective_date between PPS.date_start and
17: nvl(PPS.actual_termination_date,to_date('4712/12/31', 'YYYY/MM/DD'));