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 1075: per_assignments_f asg

1071:
1072: cursor cur_date_of_hire is
1073: select max(service.date_start) hire_date
1074: from per_periods_of_service service,
1075: per_assignments_f asg
1076: where asg.assignment_id = p_assignment_id
1077: and p_end_date BETWEEN
1078: asg.effective_start_date
1079: AND asg.effective_end_date