DBA Data[Home] [Help]

APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_FP_CALC_AMT_TMP1

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

1476: l_index_tab(i) := i;
1477: END LOOP;
1478:
1479: -- We need to sort the pl/sql records by (RA id, currency code, start date)
1480: -- The pa_fp_calc_amt_tmp1 table should be unused now; use it to sort.
1481: DELETE PA_FP_ROLLUP_TMP;
1482: FORALL i IN 1..l_cal_tgt_res_asg_id_tab.count
1483: INSERT INTO PA_FP_ROLLUP_TMP (
1484: ROLLUP_ID, -- l_cal_ table index value

Line 1768: FROM pa_fp_calc_amt_tmp1 tmp1,

1764: BULK COLLECT
1765: INTO l_sr_src_ra_id_tab,
1766: l_sr_tgt_ra_id_tab,
1767: l_sr_txn_currency_code_tab
1768: FROM pa_fp_calc_amt_tmp1 tmp1,
1769: pa_tasks ta,
1770: pa_fp_rollup_tmp cmt
1771: WHERE tmp1.transaction_source_code = 'FINANCIAL_PLAN' -- C. check finplan
1772: AND tmp1.target_res_asg_id = cmt.resource_assignment_id