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 PQH_FR_UTILITY

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

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
611: AND sit.sub_type = NVL(p_sub_type,sub_type)
612: AND sit.default_flag = 'Y'

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

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