238: SELECT prjpip.ID into G_Period_Type_ID
239: -- ,prjbab.value
240: FROM
241: pji_system_settings syssetting
242: , pji_period_types_v prjpip
243: , pji_period_types_v prjbab
244: WHERE
245: prjbab.global_disp_flag = 0
246: AND prjpip.global_disp_flag = 0
239: -- ,prjbab.value
240: FROM
241: pji_system_settings syssetting
242: , pji_period_types_v prjpip
243: , pji_period_types_v prjbab
244: WHERE
245: prjbab.global_disp_flag = 0
246: AND prjpip.global_disp_flag = 0
247: AND prjpip.ID='FII_TIME_'||DECODE(G_Period_Type_Code,