eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_VAC_BANK dependencies on PER_ALL_ASSIGNMENTS_F

Line 21: FROM per_all_assignments_f asg,

17: RETURN NUMBER IS
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