APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_FP_GEN_RATE_TMP

Line 476: * This procedure populates the PA_FP_GEN_RATE_TMP table with values from the

472: END UPD_NRB_TXN_OVR_RATES;
473:
474:
475: /**
476: * This procedure populates the PA_FP_GEN_RATE_TMP table with values from the
477: * PA_BUDGET_LINES table for the given (source resource assignment, txn currency code)
478: * parameter combination.
479: *
480: * The target resource assignment id is currently unused.

Line 543: INSERT INTO PA_FP_GEN_RATE_TMP

539:
540: /* Bug 4117267 added TARGET_RES_ASG_ID column in the INSERT stmt. */
541:
542: FORALL i IN 1..l_period_name_tab.count
543: INSERT INTO PA_FP_GEN_RATE_TMP
544: ( SOURCE_RES_ASG_ID,
545: TXN_CURRENCY_CODE,
546: PERIOD_NAME,
547: RAW_COST_RATE,

Line 4845: DELETE from PA_FP_GEN_RATE_TMP;

4841: END LOOP;
4842:
4843:
4844:
4845: DELETE from PA_FP_GEN_RATE_TMP;
4846: FOR kk in l_ra_id_tbl_1.FIRST .. l_ra_id_tbl_1.LAST
4847: LOOP
4848:
4849: l_calc_cur_txn_flag := 'N';

Line 5614: INSERT INTO PA_FP_GEN_RATE_TMP

5610: END IF;-- l_fp_cols_rec.x_time_phased_code
5611:
5612: IF l_calc_cur_txn_flag = 'Y' and l_period_rates_tbl.count > 0 THEN -- Added and condition for Bug8681973
5613: FOR j IN l_period_rates_tbl.FIRST..l_period_rates_tbl.LAST LOOP
5614: INSERT INTO PA_FP_GEN_RATE_TMP
5615: ( TXN_CURRENCY_CODE,
5616: PERIOD_NAME,
5617: RAW_COST_RATE,
5618: BURDENED_COST_RATE,