DBA Data[Home] [Help]

APPS.HR_PL_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 958: from per_all_assignments_f

954: p_days OUT NOCOPY NUMBER) return number is
955:
956: cursor csr_person_id is
957: select person_id
958: from per_all_assignments_f
959: where assignment_id=p_assignment_id;
960:
961: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is
962: select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date