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 PQH_CORPS_DEFINITIONS

Line 1495: FROM pqh_corps_definitions

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)
1497: AND p_effective_date BETWEEN date_from
1498: AND NVL(date_to,HR_GENERAL.end_of_time))
1499: AND p_effective_date BETWEEN effective_start_date

Line 1505: FROM pqh_corps_definitions

1501: --
1502: --Cursor to fetch working hours.
1503: CURSOR csr_working_hours(p_ben_pgm_id NUMBER) IS
1504: SELECT NVL(normal_hours,0), NVL(normal_hours_frequency,'X')
1505: FROM pqh_corps_definitions
1506: WHERE ben_pgm_id = p_ben_pgm_id
1507: AND p_effective_date BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time);
1508: --
1509: --Variable Declarations.

Line 1958: From Pqh_Corps_Definitions

1954:
1955: --Cursor to get the Corp id for the Career Definition for the person
1956: Cursor csr_career_corp is
1957: Select Corps_Definition_Id
1958: From Pqh_Corps_Definitions
1959: where Ben_Pgm_Id in (select grade_ladder_pgm_id
1960: from per_all_assignments_f
1961: where assignment_id = p_primary_assign_id
1962: and p_effective_date between effective_start_date and effective_end_date