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_ROE_EI_PKG dependencies on PER_ASSIGNMENTS_F

Line 62: per_assignments_f asg

58: p_end_date DATE,
59: p_start_date DATE) IS
60: SELECT MAX(service.date_start) hire_date
61: FROM per_periods_of_service service,
62: per_assignments_f asg
63: WHERE asg.assignment_id = p_asg_id
64: AND p_end_date BETWEEN
65: asg.effective_start_date
66: AND asg.effective_end_date

Line 1235: per_assignments_f asg

1231:
1232: cursor cur_date_of_hire is
1233: select max(service.date_start) hire_date
1234: from per_periods_of_service service,
1235: per_assignments_f asg
1236: where asg.assignment_id = p_assignment_id
1237: and p_end_date BETWEEN
1238: asg.effective_start_date
1239: AND asg.effective_end_date