DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_PERIODS_ALL

Line 86: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

82: sum(DECODE(c_multi_currency_flag,
83: 'Y', pji_tmp.pou_revenue,
84: 'N', pji_tmp.prj_revenue,
85: 'A', pji_tmp.pou_revenue))
86: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
87: WHERE c_version_type = 'ALL'
88: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
89: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
90: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR

Line 134: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

130: sum(DECODE(c_multi_currency_flag,
131: 'Y', pji_tmp.pou_revenue,
132: 'N', pji_tmp.prj_revenue,
133: 'A', pji_tmp.pou_revenue))
134: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
135: WHERE c_version_type = 'COST'
136: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
137: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
138: (NVL(pji_tmp.quantity,0) <> 0)

Line 181: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

177: sum(DECODE(c_multi_currency_flag,
178: 'Y', pji_tmp.pou_revenue,
179: 'N', pji_tmp.prj_revenue,
180: 'A', pji_tmp.pou_revenue))
181: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
182: WHERE c_version_type = 'REVENUE'
183: AND (
184: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR
185: (NVL(pji_tmp.quantity,0) <> 0)