APPS.PA_FP_COPY_ACTUALS_PUB dependencies on GL_PERIOD_STATUSES

Line 245: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

241: sum(DECODE(c_multi_currency_flag,
242: 'Y', pji_tmp.pou_revenue,
243: 'N', pji_tmp.prj_revenue,
244: 'A', pji_tmp.pou_revenue))
245: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
246: WHERE c_version_type = 'ALL'
247: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
248: (NVL(pji_tmp.prj_raw_cost, 0) <> 0) OR --Bug 9666017
249: (NVL(pji_tmp.pou_raw_cost, 0) <> 0) OR --Bug 9666017

Line 301: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

297: sum(DECODE(c_multi_currency_flag,
298: 'Y', pji_tmp.pou_revenue,
299: 'N', pji_tmp.prj_revenue,
300: 'A', pji_tmp.pou_revenue))
301: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
302: WHERE c_version_type = 'COST'
303: AND (
304: (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
305: (NVL(pji_tmp.prj_raw_cost, 0) <> 0) OR --Bug 9666017

Line 355: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

351: sum(DECODE(c_multi_currency_flag,
352: 'Y', pji_tmp.pou_revenue,
353: 'N', pji_tmp.prj_revenue,
354: 'A', pji_tmp.pou_revenue))
355: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
356: WHERE c_version_type = 'REVENUE'
357: AND (
358: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR
359: (NVL(pji_tmp.prj_revenue, 0) <> 0) OR --Bug 9666017

Line 2274: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

2270: sum(DECODE(c_multi_currency_flag,
2271: 'Y', pji_tmp.pou_revenue,
2272: 'N', pji_tmp.prj_revenue,
2273: 'A', pji_tmp.pou_revenue)) pou_revenue
2274: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
2275: WHERE c_version_type = 'ALL'
2276: AND pji_tmp.source_id = c_source_id
2277: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
2278: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR

Line 2331: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd

2327: sum(DECODE(c_multi_currency_flag,
2328: 'Y', pji_tmp.pou_revenue,
2329: 'N', pji_tmp.prj_revenue,
2330: 'A', pji_tmp.pou_revenue)) pou_revenue
2331: FROM pji_fm_xbs_accum_tmp1 pji_tmp,gl_period_statuses gd
2332: WHERE c_version_type = 'COST'
2333: AND pji_tmp.source_id = c_source_id
2334: AND (
2335: (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR

Line 2357: p_period_name gl_period_statuses.period_name%type,

2353: l_budget_line_gl_rec budget_line_cursor_gl%rowtype;
2354:
2355: -- Cursor to get GL period start date and end date
2356: cursor gl_period_start_end_dates_csr(
2357: p_period_name gl_period_statuses.period_name%type,
2358: p_set_of_books_id gl_period_statuses.set_of_books_id%type)
2359: is
2360: select start_date, end_date
2361: from gl_period_statuses

Line 2358: p_set_of_books_id gl_period_statuses.set_of_books_id%type)

2354:
2355: -- Cursor to get GL period start date and end date
2356: cursor gl_period_start_end_dates_csr(
2357: p_period_name gl_period_statuses.period_name%type,
2358: p_set_of_books_id gl_period_statuses.set_of_books_id%type)
2359: is
2360: select start_date, end_date
2361: from gl_period_statuses
2362: where period_name = p_period_name

Line 2361: from gl_period_statuses

2357: p_period_name gl_period_statuses.period_name%type,
2358: p_set_of_books_id gl_period_statuses.set_of_books_id%type)
2359: is
2360: select start_date, end_date
2361: from gl_period_statuses
2362: where period_name = p_period_name
2363: and set_of_books_id = p_set_of_books_id;
2364:
2365: -- Cursor to get PA period start date and end date