APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_FP_CALC_AMT_TMP2

Line 313: INSERT INTO PA_FP_CALC_AMT_TMP2

309: hr_utility.trace('budget ver id '||p_budget_version_id) ; */
310:
311: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
312:
313: INSERT INTO PA_FP_CALC_AMT_TMP2
314: (resource_assignment_id,
315: txn_currency_code,
316: total_plan_quantity,
317: total_txn_raw_cost,

Line 467: INSERT INTO PA_FP_CALC_AMT_TMP2

463: WHERE ra.budget_version_id = l_source_bv_id);
464:
465: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
466:
467: INSERT INTO PA_FP_CALC_AMT_TMP2
468: (resource_assignment_id,
469: txn_currency_code,
470: total_plan_quantity,
471: total_txn_raw_cost,

Line 624: INSERT INTO PA_FP_CALC_AMT_TMP2

620: AND v.proj_element_id = ra.task_id);
621:
622: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
623:
624: INSERT INTO PA_FP_CALC_AMT_TMP2
625: (resource_assignment_id,
626: txn_currency_code,
627: total_plan_quantity,
628: total_txn_raw_cost,

Line 1171: INSERT INTO pa_fp_calc_amt_tmp2

1167: END LOOP;
1168:
1169: /* bulk insert */
1170: FORALL m IN 1..l_res_asn_id_tab.count
1171: INSERT INTO pa_fp_calc_amt_tmp2
1172: (resource_assignment_id,
1173: total_pc_raw_cost,
1174: total_pc_burdened_cost,
1175: total_pc_revenue,

Line 1200: FROM pa_fp_calc_amt_tmp2;

1196: INTO x_txn_amt_rec.quantity_sum,
1197: x_txn_amt_rec.txn_raw_cost_sum,
1198: x_txn_amt_rec.txn_burdened_cost_sum,
1199: x_txn_amt_rec.txn_revenue_sum
1200: FROM pa_fp_calc_amt_tmp2;
1201: */
1202: IF p_pa_debug_mode = 'Y' THEN
1203: PA_DEBUG.Reset_Curr_Function;
1204: END IF;

Line 1305: from PA_FP_CALC_AMT_TMP2

1301: LAST_UPDATE_LOGIN = l_last_update_login
1302: WHERE budget_version_id = p_budget_version_id
1303: and (resource_assignment_id,txn_currency_code) in
1304: (select target_res_asg_id,etc_currency_code
1305: from PA_FP_CALC_AMT_TMP2
1306: where transaction_source_code = 'ETC');
1307: -- Above and clause added for bug 4247647 ...
1308:
1309: IF p_pa_debug_mode = 'Y' THEN