APPS.HR_US_FF_UDF1 dependencies on PER_PERIODS_OF_SERVICE

Line 2378: Bug#7655549: per_periods_of_service should be used to check employee's

2374: and p_date_earned between paaf.effective_start_date
2375: and paaf.effective_end_date;
2376:
2377: /* Checks whether the employee is valid as of last date of the pay period.
2378: Bug#7655549: per_periods_of_service should be used to check employee's
2379: Validity. */
2380: CURSOR CSR_GET_VALID_EMPLOYMENT IS
2381: select 1
2382: from per_periods_of_service

Line 2382: from per_periods_of_service

2378: Bug#7655549: per_periods_of_service should be used to check employee's
2379: Validity. */
2380: CURSOR CSR_GET_VALID_EMPLOYMENT IS
2381: select 1
2382: from per_periods_of_service
2383: where person_id = l_person_id
2384: and l_date between date_start and nvl(actual_termination_date,to_date('12/31/4712','MM/DD/YYYY'));
2385:
2386:

Line 2836: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

2832: l_effective_start_date DATE;
2833: l_max_start_date DATE;
2834: l_effective_end_date DATE;
2835: l_max_end_date DATE;
2836: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
2837:
2838: -- Get actual_termination_date for the person
2839: 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
2840: SELECT pps.actual_termination_date,pps.date_start

Line 2841: FROM per_periods_of_service pps,

2837:
2838: -- Get actual_termination_date for the person
2839: 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
2840: SELECT pps.actual_termination_date,pps.date_start
2841: FROM per_periods_of_service pps,
2842: per_all_assignments_f paa
2843: WHERE paa.assignment_id = p_assignment_id
2844: AND paa.person_id = pps.person_id
2845: AND p_date_earned BETWEEN paa.effective_start_date