Line 803: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
799: (SELECT statutory_situation_id
800: FROM pqh_fr_stat_situations_v sit,
801: per_shared_types_vl sh
802: WHERE sh.shared_type_id = type_of_ps 803: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd) 804: AND sit.business_group_id = HR_GENERAL.get_business_group_id
805: AND sit.default_flag = 'Y'
806: AND sit.situation_type = 'IA'
807: AND sit.sub_type = 'IA_N'