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 PQH_FR_UTILITY

Line 79: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)

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'
82: AND sit.situation_type = 'IA'
83: AND sit.sub_type = 'IA_N'

Line 888: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)

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'
891: AND sit.situation_type = 'IA'
892: AND sit.sub_type = 'IA_N'