APPS.PAY_CA_VAC_BANK dependencies on PER_PERIODS_OF_SERVICE

Line 12: * PER_PERIODS_OF_SERVICE as the starting_point

8: * DESCRIPTION
9: * This is a function that calculates the effective years of service,
10: * rounded down to a whole year, based on the entered DATE_TYPE.
11: * 'Hire Date' - The years of service is calculated using the hire date on
12: * PER_PERIODS_OF_SERVICE as the starting_point
13: */
14: FUNCTION calc_years_of_service(p_assignment_id NUMBER,
15: p_date_earned DATE,
16: p_date_type VARCHAR2)

Line 22: per_periods_of_service pds

18:
19: CURSOR c_years_of_service IS
20: SELECT TRUNC(MONTHS_BETWEEN(p_date_earned, pds.date_start)/12)
21: FROM per_all_assignments_f asg,
22: per_periods_of_service pds
23: WHERE asg.assignment_id = p_assignment_id
24: AND p_date_earned BETWEEN asg.effective_start_date
25: AND asg.effective_end_date
26: AND pds.person_id = asg.person_id;