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.ARP_CMREQ_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 1622: FROM per_all_assignments_f hremp

1618:
1619: BEGIN
1620: SELECT hremp.supervisor_id
1621: INTO l_supervisor_emp_id
1622: FROM per_all_assignments_f hremp
1623: WHERE hremp.person_id = l_employee_id
1624: AND primary_flag = 'Y' -- get primary assgt
1625: AND assignment_type = 'E' -- ensure emp assgt, not applicant assgt
1626: AND trunc(sysdate) BETWEEN hremp.effective_start_date AND

Line 2114: FROM per_all_assignments_f hremp

2110: Close c1;
2111:
2112: SELECT hremp.supervisor_id
2113: INTO l_manager_id
2114: FROM per_all_assignments_f hremp
2115: WHERE hremp.person_id = l_employee_id
2116: AND primary_flag = 'Y' -- get primary assgt
2117: AND assignment_type = 'E' -- ensure emp assgt, not applicant assgt
2118: AND trunc(sysdate) BETWEEN hremp.effective_start_date AND