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_STAT_SIT_UTIL dependencies on PER_SHARED_TYPES_VL

Line 606: ,per_shared_types_vl sh

602: p_sub_type IN VARCHAR2,
603: p_eff_date IN DATE) IS
604: SELECT statutory_situation_id
605: FROM pqh_fr_stat_situations_v sit
606: ,per_shared_types_vl sh
607: WHERE sh.shared_type_id = type_of_ps
608: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
609: AND sit.business_group_id = p_business_group_id
610: AND sit.situation_type = p_situation_type

Line 741: ,per_shared_types_vl sh

737: FROM pqh_fr_emp_stat_situations
738: WHERE person_id = p_person_id
739: AND statutory_situation_id NOT IN (SELECT statutory_situation_id
740: FROM pqh_fr_stat_situations_v sit
741: ,per_shared_types_vl sh
742: WHERE sh.shared_type_id = type_of_ps
743: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
744: AND sit.business_group_id= HR_GENERAL.get_business_group_id
745: AND sit.default_flag = 'Y'