[Home] [Help]
176: END IF;
177:
178:
179: --------------------------------------------------------------------------
180: --Insert data FROM fii_gl_base_map_mv by joining to fii_time_structures.
181: --Here we calculate XTD amounts for all four days at same time; the sql
182: --query is similar to what we have for PMV reports (using bitand function)
183: --------------------------------------------------------------------------
184:
696: g_fii_sysdate,
697: g_fii_user_id,
698: g_fii_login_id
699:
700: FROM fii_time_structures cal,
701: fii_gl_base_map_mv b
702: WHERE cal.report_date in (l_this_date, l_pp_this_date,
703: l_pq_this_date, l_ly_this_date, l_this_date_gov)
704: AND cal.time_id = b.time_id
1221: prim_amount_g, sec_amount_g, obligated_amount_prim,
1222: other_amount_prim, committed_amount_prim,
1223: b.time_id, b.period_type_id, cal.record_type_id
1224: FROM fii_gl_je_summary_b b,
1225: fii_time_structures cal
1226:
1227: WHERE cal.report_date = l_this_date
1228: AND cal.time_id = b.time_id
1229: AND cal.period_type_id = b.period_type_id
1251: prim_amount_g, sec_amount_g, baseline_amount_prim,
1252: b.time_id, b.period_type_id, cal.record_type_id
1253:
1254: FROM fii_budget_base b,
1255: fii_time_structures cal
1256:
1257: WHERE cal.report_date = l_this_date
1258: AND b.plan_type_code = 'B'
1259: AND b.period_type_id = cal.period_type_id
1280: obligated_amount_prim,
1281: other_amount_prim, committed_amount_prim,
1282: b.time_id, b.period_type_id, cal.record_type_id
1283: FROM fii_gl_enc_carryfwd_f b,
1284: fii_time_structures cal
1285:
1286: WHERE cal.report_date = l_this_date
1287: AND cal.time_id = b.time_id
1288: AND cal.period_type_id = b.period_type_id
1759: prim_amount_g, sec_amount_g,
1760: b.time_id, b.period_type_id, cal.record_type_id
1761:
1762: FROM fii_gl_je_summary_b b,
1763: fii_time_structures cal
1764:
1765: WHERE cal.report_date = l_this_date
1766: AND cal.time_id = b.time_id
1767: AND cal.period_type_id = b.period_type_id