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_SHARED_TYPES_VL

Line 77: ,per_shared_types_vl sh

73: FROM pqh_fr_emp_stat_situations
74: WHERE person_id = p_person_id
75: AND statutory_situation_id IN (SELECT statutory_situation_id
76: FROM pqh_fr_stat_situations_v sit
77: ,per_shared_types_vl sh
78: WHERE sh.shared_type_id = type_of_ps
79: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
80: AND sit.business_group_id = HR_GENERAL.get_business_group_id
81: AND sit.default_flag = 'Y'

Line 886: ,per_shared_types_vl sh

882: FROM pqh_fr_emp_stat_situations
883: WHERE person_id = p_person_id
884: AND statutory_situation_id IN(SELECT statutory_situation_id
885: FROM pqh_fr_stat_situations_v sit
886: ,per_shared_types_vl sh
887: WHERE sh.shared_type_id = type_of_ps
888: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
889: AND sit.business_group_id = HR_GENERAL.get_business_group_id
890: AND sit.default_flag = 'Y'