DBA Data[Home] [Help]

APPS.HR_PL_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 1004: from per_all_assignments_f

1000: p_days OUT NOCOPY NUMBER) return number is
1001:
1002: cursor csr_person_id is
1003: select person_id
1004: from per_all_assignments_f
1005: where assignment_id=p_assignment_id;
1006:
1007: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is
1008: select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date