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 4821: DELETE from PA_FP_GEN_RATE_TMP;

4817: END LOOP;
4818:
4819:
4820:
4821: DELETE from PA_FP_GEN_RATE_TMP;
4822: FOR kk in l_ra_id_tbl_1.FIRST .. l_ra_id_tbl_1.LAST
4823: LOOP
4824:
4825: l_calc_cur_txn_flag := 'N';

Line 5510: INSERT INTO PA_FP_GEN_RATE_TMP

5506: END IF;-- l_fp_cols_rec.x_time_phased_code
5507:
5508: IF l_calc_cur_txn_flag = 'Y' THEN
5509: FOR j IN l_period_rates_tbl.FIRST..l_period_rates_tbl.LAST LOOP
5510: INSERT INTO PA_FP_GEN_RATE_TMP
5511: ( TXN_CURRENCY_CODE,
5512: PERIOD_NAME,
5513: RAW_COST_RATE,
5514: BURDENED_COST_RATE,