APPS.PA_FP_MAP_BV_PUB dependencies on PA_FP_CALC_AMT_TMP3

Line 21: SELECT /*+ INDEX(t3,PA_FP_CALC_AMT_TMP3_N2)*/

17: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_map_bv_pub.gen_map_bv_to_target_rl';
18:
19: CURSOR txn_sum_csr(c_project_currency_code PA_BUDGET_LINES.PROJECT_CURRENCY_CODE%TYPE,
20: c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE)IS
21: SELECT /*+ INDEX(t3,PA_FP_CALC_AMT_TMP3_N2)*/
22: t3.res_list_member_id,
23: ra.task_id,
24: decode(c_multi_curr_flag,'Y',bl.txn_currency_code,
25: 'N',c_project_currency_code),

Line 41: pa_fp_calc_amt_tmp3 t3

37: sum(bl.burdened_cost),
38: sum(bl.revenue)
39: FROM pa_resource_assignments ra,
40: pa_budget_lines bl,
41: pa_fp_calc_amt_tmp3 t3
42: WHERE ra.resource_assignment_id = bl.resource_assignment_id
43: AND ra.resource_assignment_id = t3.res_asg_id
44: AND ra.budget_version_id = p_source_bv_id
45: AND bl.end_date <= nvl(p_actual_thru_date,bl.end_date)

Line 249: INSERT INTO PA_FP_CALC_AMT_TMP3

245: END IF;
246: /* dbms_output.put_line('Status of map_rlmi_rbs api: '
247: ||X_RETURN_STATUS); */
248: FORALL i IN 1..l_res_list_member_id_tab.count
249: INSERT INTO PA_FP_CALC_AMT_TMP3
250: (plan_version_id,
251: res_list_member_id,
252: res_asg_id)
253: VALUES

Line 267: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N2)*/

263: WHERE ra.budget_version_id = p_etc_fp_cols_rec.
264: x_budget_version_id;
265:
266: FORALL m in 1..l_tsk_id_tab.count
267: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N2)*/
268: PA_FP_CALC_AMT_TMP3
269: SET task_id = l_tsk_id_tab(m)
270: WHERE res_asg_id = l_resrc_assgn_id(m);
271:

Line 268: PA_FP_CALC_AMT_TMP3

264: x_budget_version_id;
265:
266: FORALL m in 1..l_tsk_id_tab.count
267: UPDATE /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N2)*/
268: PA_FP_CALC_AMT_TMP3
269: SET task_id = l_tsk_id_tab(m)
270: WHERE res_asg_id = l_resrc_assgn_id(m);
271:
272: OPEN txn_sum_csr(p_target_fp_cols_rec.x_project_currency_code,

Line 291: DELETE /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N1)*/

287: l_pfc_burdend_cost_sum_tab,
288: l_pfc_revenue_sum_tab;
289: CLOSE txn_sum_csr;
290:
291: DELETE /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N1)*/
292: FROM pa_fp_calc_amt_tmp3
293: WHERE plan_version_id =
294: P_ETC_FP_COLS_REC.x_budget_version_id;
295:

Line 292: FROM pa_fp_calc_amt_tmp3

288: l_pfc_revenue_sum_tab;
289: CLOSE txn_sum_csr;
290:
291: DELETE /*+ INDEX(PA_FP_CALC_AMT_TMP3,PA_FP_CALC_AMT_TMP3_N1)*/
292: FROM pa_fp_calc_amt_tmp3
293: WHERE plan_version_id =
294: P_ETC_FP_COLS_REC.x_budget_version_id;
295:
296: FORALL k in 1..l_txn_src_id_tab.count

Line 297: INSERT INTO pa_fp_calc_amt_tmp3

293: WHERE plan_version_id =
294: P_ETC_FP_COLS_REC.x_budget_version_id;
295:
296: FORALL k in 1..l_txn_src_id_tab.count
297: INSERT INTO pa_fp_calc_amt_tmp3
298: (plan_version_id,
299: task_id,
300: res_list_member_id,
301: res_asg_id,

Line 330: INSERT INTO PA_FP_CALC_AMT_TMP3

326: l_pfc_burdend_cost_sum_tab(k),
327: l_pfc_revenue_sum_tab(k));
328: ELSIF p_cb_fp_cols_rec.x_resource_list_id =
329: p_etc_fp_cols_rec.x_resource_list_id THEN
330: INSERT INTO PA_FP_CALC_AMT_TMP3
331: (plan_version_id,
332: task_id,
333: res_list_member_id,
334: res_asg_id,

Line 389: INSERT INTO PA_FP_CALC_AMT_TMP3

385: 'Y',bl.txn_currency_code,
386: 'N',p_target_fp_cols_rec.x_project_currency_code));
387:
388: ELSIF l_rl_uncategorized_flag = 'N' THEN
389: INSERT INTO PA_FP_CALC_AMT_TMP3
390: (plan_version_id,
391: task_id,
392: res_list_member_id,
393: res_asg_id,