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 2522: delete from pa_fp_calc_amt_tmp2;

2518:
2519: IF l_fp_cols_rec_target.x_version_type = 'REVENUE'
2520: AND l_rev_gen_method = 'C'
2521: AND l_wp_track_cost_flag <> 'Y' THEN
2522: delete from pa_fp_calc_amt_tmp2;
2523: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2524: INSERT INTO pa_fp_calc_amt_tmp2(
2525: resource_assignment_id,
2526: txn_currency_code,

Line 2524: INSERT INTO pa_fp_calc_amt_tmp2(

2520: AND l_rev_gen_method = 'C'
2521: AND l_wp_track_cost_flag <> 'Y' THEN
2522: delete from pa_fp_calc_amt_tmp2;
2523: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2524: INSERT INTO pa_fp_calc_amt_tmp2(
2525: resource_assignment_id,
2526: txn_currency_code,
2527: TOTAL_PLAN_QUANTITY)
2528: VALUES(

Line 5174: DELETE PA_FP_CALC_AMT_TMP2;

5170: FOR i IN 1..l_tgt_res_asg_id_tab.count LOOP
5171: l_index_tab(i) := i;
5172: END LOOP;
5173:
5174: DELETE PA_FP_CALC_AMT_TMP2;
5175: -- The ETC_PLAN_QUANTITY is used to store the pl/sql table index.
5176: FORALL i IN 1..l_tgt_res_asg_id_tab.count
5177: INSERT INTO PA_FP_CALC_AMT_TMP2 (
5178: ETC_PLAN_QUANTITY,

Line 5177: INSERT INTO PA_FP_CALC_AMT_TMP2 (

5173:
5174: DELETE PA_FP_CALC_AMT_TMP2;
5175: -- The ETC_PLAN_QUANTITY is used to store the pl/sql table index.
5176: FORALL i IN 1..l_tgt_res_asg_id_tab.count
5177: INSERT INTO PA_FP_CALC_AMT_TMP2 (
5178: ETC_PLAN_QUANTITY,
5179: RESOURCE_ASSIGNMENT_ID,
5180: TXN_CURRENCY_CODE )
5181: VALUES (

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

5183: l_tgt_res_asg_id_tab(i),
5184: l_txn_currency_code_tab(i) );
5185:
5186: /* Get indices for budget lines we need to UPDATE */
5187: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
5188: tmp.ETC_PLAN_QUANTITY
5189: BULK COLLECT INTO l_upd_index_tab
5190: FROM pa_budget_lines bl,
5191: pa_fp_calc_amt_tmp2 tmp

Line 5191: pa_fp_calc_amt_tmp2 tmp

5187: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
5188: tmp.ETC_PLAN_QUANTITY
5189: BULK COLLECT INTO l_upd_index_tab
5190: FROM pa_budget_lines bl,
5191: pa_fp_calc_amt_tmp2 tmp
5192: WHERE bl.budget_version_id = P_TARGET_BV_ID
5193: AND bl.resource_assignment_id = tmp.resource_assignment_id
5194: AND bl.txn_currency_code = tmp.txn_currency_code
5195: ORDER BY tmp.ETC_PLAN_QUANTITY ASC;