[Home] [Help]
27:
28: l_as_of_date := fii_ea_util_pkg.g_as_of_date;
29:
30: -- to find out the year start date and END date
31: SELECT NVL(MIN(start_date), trunc(sysdate)) INTO l_min_start_date FROM fii_time_ent_period;
32:
33: SELECT NVL(fii_time_api.ent_cyr_start(l_as_of_date), l_min_start_date)
34: INTO l_curr_per_start FROM DUAL;
35:
97: THEN (f.COMMITTED_AMOUNT_PRIM + f.OBLIGATED_AMOUNT_PRIM +
98: f.OTHER_AMOUNT_PRIM) ELSE 0 END) FII_PSI_ENCUMBRANCES_A,
99: 0 FII_PSI_ACTUALS_A
100: FROM fii_time_structures cal,
101: fii_time_ent_period t,
102: fii_gl_trend_sum_mv f
103: WHERE f.time_id = cal.time_id
104: AND f.period_type_id = cal.period_type_id
105: AND bitand(cal.record_type_id, 256) = 256
117: 0 FII_PSI_BUDGET_A,
118: 0 FII_PSI_ENCUMBRANCES_A,
119: SUM(f.PRIM_ACTUAL_G) FII_PSI_ACTUALS_A
120: FROM fii_time_structures cal,
121: fii_time_ent_period t,
122: fii_gl_trend_sum_mv f
123: WHERE f.time_id = cal.time_id
124: AND f.period_type_id = cal.period_type_id
125: AND BITAND(cal.record_type_id, 256) = 256
152: AND cal.report_date = :ASOF_DATE
153: '||l_company_security||l_cost_center_security||'
154: AND top_node_fin_cat_type = ''OE''
155: GROUP BY cal.report_date ) f1,
156: fii_time_ent_period t
157: WHERE t.start_date >= :CURR_PERIOD_START
158: AND t.end_date >= :ASOF_DATE
159: AND t.end_date <= :CURR_PERIOD_END
160: ) f2,
157: WHERE t.start_date >= :CURR_PERIOD_START
158: AND t.end_date >= :ASOF_DATE
159: AND t.end_date <= :CURR_PERIOD_END
160: ) f2,
161: fii_time_ent_period t
162: WHERE t.start_date >= :CURR_PERIOD_START
163: AND t.end_date >= :CURR_PERIOD_START
164: AND t.end_date <= :CURR_PERIOD_END
165: AND t.ent_period_id = f2.fii_psi_period_id(+)