[Home] [Help]
61: END IF;
62: If p_period_type is not null then
63: CASE p_period_type
64: WHEN 'FII_TIME_WEEK' THEN p_record_type_id := 32;
65: WHEN 'FII_TIME_ENT_PERIOD' THEN p_record_type_id := 64;
66: WHEN 'FII_TIME_ENT_QTR' THEN p_record_type_id := 128;
67: WHEN 'FII_TIME_ENT_YEAR' THEN p_record_type_id := 256;
68: END CASE;
69: End if;
128:
129: END CASE;
130:
131: SELECT name INTO stmt
132: FROM fii_time_ent_period
133: WHERE l_temp_date = end_date;
134:
135: ELSE
136: RETURN NULL;