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_ASSIGNMENT_API dependencies on PQH_CORPS_DEFINITIONS

Line 1214: FROM pqh_corps_definitions

1210: --
1211: --Cursor to fetch Working Hours from Corps for Fonctionaire else from Estab Info for Non Titulaires.
1212: CURSOR csr_normal_working_hour IS
1213: SELECT normal_hours hours, normal_hours_frequency frequency
1214: FROM pqh_corps_definitions
1215: WHERE ben_pgm_id = (SELECT grade_ladder_pgm_id
1216: FROM per_all_assignments_f
1217: WHERE assignment_id = p_assignment_id
1218: AND p_effective_date BETWEEN effective_start_date AND effective_end_date)

Line 1533: FROM pqh_corps_definitions

1529: --
1530: CURSOR csr_get_corps_info
1531: IS
1532: SELECT normal_hours, normal_hours_frequency
1533: FROM pqh_corps_definitions
1534: WHERE ben_pgm_id = p_corps_id
1535: AND p_effective_date BETWEEN date_from
1536: AND NVL (date_to, hr_general.end_of_time);
1537: