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

Line 1366: FROM per_all_assignments_f asg,

1362: --
1363: --Cursor to get current Situation details
1364: CURSOR csr_asg_dtls IS
1365: SELECT asg.assignment_id, asg.effective_start_date, asg.effective_end_date, ast.per_system_status
1366: FROM per_all_assignments_f asg,
1367: per_assignment_status_types ast
1368: WHERE asg.person_id = p_person_id
1369: AND(TRUNC(asg.effective_start_date) BETWEEN TRUNC(p_start_date) AND TRUNC(p_end_date)
1370: OR TRUNC(asg.effective_end_date) BETWEEN TRUNC(p_start_date) AND TRUNC(p_end_date))