APPS.HR_US_FF_UDF1 dependencies on PER_PERIODS_OF_SERVICE

Line 2737: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

2733: l_effective_start_date DATE;
2734: l_max_start_date DATE;
2735: l_effective_end_date DATE;
2736: l_max_end_date DATE;
2737: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
2738:
2739: -- Get actual_termination_date for the person
2740: CURSOR csr_term_dates(p_assignment_id IN NUMBER, p_date_earned IN DATE,p_date_start IN DATE,p_date_end IN DATE ) IS
2741: SELECT pps.actual_termination_date,pps.date_start

Line 2742: FROM per_periods_of_service pps,

2738:
2739: -- Get actual_termination_date for the person
2740: CURSOR csr_term_dates(p_assignment_id IN NUMBER, p_date_earned IN DATE,p_date_start IN DATE,p_date_end IN DATE ) IS
2741: SELECT pps.actual_termination_date,pps.date_start
2742: FROM per_periods_of_service pps,
2743: per_all_assignments_f paa
2744: WHERE paa.assignment_id = p_assignment_id
2745: AND paa.person_id = pps.person_id
2746: AND p_date_earned BETWEEN paa.effective_start_date