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.prj_raw_cost, 0) <> 0) OR --Bug 9666017
90: (NVL(pji_tmp.pou_raw_cost, 0) <> 0) OR --Bug 9666017

Line 140: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

136: sum(DECODE(c_multi_currency_flag,
137: 'Y', pji_tmp.pou_revenue,
138: 'N', pji_tmp.prj_revenue,
139: 'A', pji_tmp.pou_revenue))
140: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
141: WHERE c_version_type = 'COST'
142: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
143: (NVL(pji_tmp.prj_raw_cost, 0) <> 0) OR --Bug 9666017
144: (NVL(pji_tmp.pou_raw_cost, 0) <> 0) OR --Bug 9666017

Line 191: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

187: sum(DECODE(c_multi_currency_flag,
188: 'Y', pji_tmp.pou_revenue,
189: 'N', pji_tmp.prj_revenue,
190: 'A', pji_tmp.pou_revenue))
191: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
192: WHERE c_version_type = 'REVENUE'
193: AND (
194: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR
195: (NVL(pji_tmp.prj_revenue, 0) <> 0) OR --Bug 9666017

Line 2165: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

2161: sum(DECODE(c_multi_currency_flag,
2162: 'Y', pji_tmp.pou_revenue,
2163: 'N', pji_tmp.prj_revenue,
2164: 'A', pji_tmp.pou_revenue))
2165: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
2166: WHERE c_version_type = 'ALL'
2167: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
2168: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
2169: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR

Line 2213: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd

2209: sum(DECODE(c_multi_currency_flag,
2210: 'Y', pji_tmp.pou_revenue,
2211: 'N', pji_tmp.prj_revenue,
2212: 'A', pji_tmp.pou_revenue))
2213: FROM pji_fm_xbs_accum_tmp1 pji_tmp,pa_periods_all pd
2214: WHERE c_version_type = 'COST'
2215: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
2216: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
2217: (NVL(pji_tmp.quantity,0) <> 0)

Line 2367: p_period_name pa_periods_all.period_name%type,

2363: and set_of_books_id = p_set_of_books_id;
2364:
2365: -- Cursor to get PA period start date and end date
2366: cursor pa_period_start_end_dates_csr(
2367: p_period_name pa_periods_all.period_name%type,
2368: p_ord_id pa_periods_all.org_id%type)
2369: is
2370: select start_date, end_date
2371: from pa_periods_all

Line 2368: p_ord_id pa_periods_all.org_id%type)

2364:
2365: -- Cursor to get PA period start date and end date
2366: cursor pa_period_start_end_dates_csr(
2367: p_period_name pa_periods_all.period_name%type,
2368: p_ord_id pa_periods_all.org_id%type)
2369: is
2370: select start_date, end_date
2371: from pa_periods_all
2372: where period_name = p_period_name

Line 2371: from pa_periods_all

2367: p_period_name pa_periods_all.period_name%type,
2368: p_ord_id pa_periods_all.org_id%type)
2369: is
2370: select start_date, end_date
2371: from pa_periods_all
2372: where period_name = p_period_name
2373: and org_id = p_ord_id;
2374:
2375: l_start_date DATE;