APPS.PA_FP_COPY_ACTUALS_PUB dependencies on GL_PERIOD_STATUSES

Line 233: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

229: sum(DECODE(c_multi_currency_flag,
230: 'Y', pji_tmp.pou_revenue,
231: 'N', pji_tmp.prj_revenue,
232: 'A', pji_tmp.pou_revenue))
233: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
234: WHERE c_version_type = 'ALL'
235: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
236: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
237: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR

Line 283: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

279: sum(DECODE(c_multi_currency_flag,
280: 'Y', pji_tmp.pou_revenue,
281: 'N', pji_tmp.prj_revenue,
282: 'A', pji_tmp.pou_revenue))
283: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
284: WHERE c_version_type = 'COST'
285: AND (
286: (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
287: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR

Line 333: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

329: sum(DECODE(c_multi_currency_flag,
330: 'Y', pji_tmp.pou_revenue,
331: 'N', pji_tmp.prj_revenue,
332: 'A', pji_tmp.pou_revenue))
333: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
334: WHERE c_version_type = 'REVENUE'
335: AND (
336: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR
337: (NVL(pji_tmp.quantity,0) <> 0)