eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_CALC_AMT_TMP2

Line 2564: delete from pa_fp_calc_amt_tmp2;

2560:
2561: IF l_fp_cols_rec_target.x_version_type = 'REVENUE'
2562: AND l_rev_gen_method = 'C'
2563: AND l_wp_track_cost_flag <> 'Y' THEN
2564: delete from pa_fp_calc_amt_tmp2;
2565: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2566: INSERT INTO pa_fp_calc_amt_tmp2(
2567: resource_assignment_id,
2568: txn_currency_code,

Line 2566: INSERT INTO pa_fp_calc_amt_tmp2(

2562: AND l_rev_gen_method = 'C'
2563: AND l_wp_track_cost_flag <> 'Y' THEN
2564: delete from pa_fp_calc_amt_tmp2;
2565: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2566: INSERT INTO pa_fp_calc_amt_tmp2(
2567: resource_assignment_id,
2568: txn_currency_code,
2569: TOTAL_PLAN_QUANTITY)
2570: VALUES(

Line 5253: DELETE PA_FP_CALC_AMT_TMP2;

5249: FOR i IN 1..l_tgt_res_asg_id_tab.count LOOP
5250: l_index_tab(i) := i;
5251: END LOOP;
5252:
5253: DELETE PA_FP_CALC_AMT_TMP2;
5254: -- The ETC_PLAN_QUANTITY is used to store the pl/sql table index.
5255: FORALL i IN 1..l_tgt_res_asg_id_tab.count
5256: INSERT INTO PA_FP_CALC_AMT_TMP2 (
5257: ETC_PLAN_QUANTITY,

Line 5256: INSERT INTO PA_FP_CALC_AMT_TMP2 (

5252:
5253: DELETE PA_FP_CALC_AMT_TMP2;
5254: -- The ETC_PLAN_QUANTITY is used to store the pl/sql table index.
5255: FORALL i IN 1..l_tgt_res_asg_id_tab.count
5256: INSERT INTO PA_FP_CALC_AMT_TMP2 (
5257: ETC_PLAN_QUANTITY,
5258: RESOURCE_ASSIGNMENT_ID,
5259: TXN_CURRENCY_CODE )
5260: VALUES (

Line 5266: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)/

5262: l_tgt_res_asg_id_tab(i),
5263: l_txn_currency_code_tab(i) );
5264:
5265: /* Get indices for budget lines we need to UPDATE */
5266: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
5267: tmp.ETC_PLAN_QUANTITY
5268: BULK COLLECT INTO l_upd_index_tab
5269: FROM pa_budget_lines bl,
5270: pa_fp_calc_amt_tmp2 tmp

Line 5270: pa_fp_calc_amt_tmp2 tmp

5266: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
5267: tmp.ETC_PLAN_QUANTITY
5268: BULK COLLECT INTO l_upd_index_tab
5269: FROM pa_budget_lines bl,
5270: pa_fp_calc_amt_tmp2 tmp
5271: WHERE bl.budget_version_id = P_TARGET_BV_ID
5272: AND bl.resource_assignment_id = tmp.resource_assignment_id
5273: AND bl.txn_currency_code = tmp.txn_currency_code
5274: ORDER BY tmp.ETC_PLAN_QUANTITY ASC;