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_UTILITY dependencies on HR_ALL_POSITIONS_F

Line 1492: FROM hr_all_positions_f

1488: AND asg.assignment_status_type_id = ast.assignment_status_type_id
1489: AND asg.primary_flag = 'N'
1490: AND p_effective_date BETWEEN asg.effective_start_date AND NVL(asg.effective_end_date,HR_GENERAL.end_of_time)
1491: AND asg.position_id NOT IN(SELECT position_id
1492: FROM hr_all_positions_f
1493: WHERE information_category = 'FR_PQH'
1494: AND information10 =(SELECT TO_CHAR(corps_definition_id)
1495: FROM pqh_corps_definitions
1496: WHERE ben_pgm_id = TO_NUMBER(p_new_ben_pgm_id)