APPS.FII_SNAP_TBL_REFRESH dependencies on FII_GL_JE_SUMMARY_B

Line 1083: -- FROM FII_GL_JE_SUMMARY_B.

1079: ----------------------------------------------------
1080: -- PROCEDURE REFRESH_GL_LOCAL_SNAP_F (private)
1081: --
1082: -- This procedure will (fully) refresh table FII_GL_LOCAL_SNAP_F
1083: -- FROM FII_GL_JE_SUMMARY_B.
1084: -- It populates data FROM GL base summary by changing rows INTO columns
1085: ----------------------------------------------------
1086: PROCEDURE REFRESH_GL_LOCAL_SNAP_F IS
1087:

Line 1211: FROM fii_gl_je_summary_b b,

1207: other_amount_prim, committed_amount_prim,
1208: b.time_id, b.period_type_id,
1209: p.ent_year_id, p.sequence period_seq, q.sequence qtr_seq
1210:
1211: FROM fii_gl_je_summary_b b,
1212: fii_time_ent_qtr q,
1213: fii_time_ent_period p
1214:
1215: WHERE b.period_type_id = 32

Line 1224: FROM fii_gl_je_summary_b b,

1220: user_dim1_id, user_dim2_id, ledger_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

Line 1749: FROM fii_gl_je_summary_b b,

1745: prim_amount_g, sec_amount_g,
1746: b.time_id, b.period_type_id,
1747: p.ent_year_id, p.sequence period_seq, q.sequence qtr_seq
1748:
1749: FROM fii_gl_je_summary_b b,
1750: fii_time_ent_qtr q,
1751: fii_time_ent_period p
1752:
1753: WHERE b.period_type_id = 32

Line 1762: FROM fii_gl_je_summary_b b,

1758: user_dim1_id, user_dim2_id, ledger_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