APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_FP_CALC_AMT_TMP1

Line 1472: -- The pa_fp_calc_amt_tmp1 table should be unused now; use it to sort.

1468: l_index_tab(i) := i;
1469: END LOOP;
1470:
1471: -- We need to sort the pl/sql records by (RA id, currency code, start date)
1472: -- The pa_fp_calc_amt_tmp1 table should be unused now; use it to sort.
1473: DELETE PA_FP_ROLLUP_TMP;
1474: FORALL i IN 1..l_cal_tgt_res_asg_id_tab.count
1475: INSERT INTO PA_FP_ROLLUP_TMP (
1476: ROLLUP_ID, -- l_cal_ table index value

Line 1760: FROM pa_fp_calc_amt_tmp1 tmp1,

1756: BULK COLLECT
1757: INTO l_sr_src_ra_id_tab,
1758: l_sr_tgt_ra_id_tab,
1759: l_sr_txn_currency_code_tab
1760: FROM pa_fp_calc_amt_tmp1 tmp1,
1761: pa_tasks ta,
1762: pa_fp_rollup_tmp cmt
1763: WHERE tmp1.transaction_source_code = 'FINANCIAL_PLAN' -- C. check finplan
1764: AND tmp1.target_res_asg_id = cmt.resource_assignment_id