APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_TXN_CURRENCIES

Line 6537: table for a budget version as txn currencies in pa_fp_txn_currencies table

6533:
6534:
6535: /******************************************************************************
6536: This api is called in calculate flow to add the currencies in budget lines
6537: table for a budget version as txn currencies in pa_fp_txn_currencies table
6538:
6539: AUG 10 2004 Raja Bug 3815266
6540: Re-written the entire code to take care of both finplan
6541: and workplan contexts. Previously refresh_wp_settings

Line 6690: FROM PA_FP_TXN_CURRENCIES TC

6686: FROM PA_BUDGET_LINES BL
6687: WHERE BL.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
6688: AND NOT EXISTS
6689: (SELECT 1
6690: FROM PA_FP_TXN_CURRENCIES TC
6691: WHERE TC.proj_fp_options_id = l_proj_fp_options_id_tbl(i) AND
6692: TC.txn_currency_code = BL.txn_currency_code);
6693:
6694: FORALL j IN 1..l_txn_curr_code_tab.count

Line 6695: INSERT INTO PA_FP_TXN_CURRENCIES

6691: WHERE TC.proj_fp_options_id = l_proj_fp_options_id_tbl(i) AND
6692: TC.txn_currency_code = BL.txn_currency_code);
6693:
6694: FORALL j IN 1..l_txn_curr_code_tab.count
6695: INSERT INTO PA_FP_TXN_CURRENCIES
6696: (
6697: FP_TXN_CURRENCY_ID,
6698: PROJ_FP_OPTIONS_ID,
6699: PROJECT_ID,

Line 6716: PA_FP_TXN_CURRENCIES_S.NEXTVAL,

6712: LAST_UPDATE_DATE
6713: )
6714: VALUES
6715: (
6716: PA_FP_TXN_CURRENCIES_S.NEXTVAL,
6717: l_proj_fp_options_id_tbl(i),
6718: l_fp_cols_rec.X_PROJECT_ID,
6719: l_fp_cols_rec.X_FIN_PLAN_TYPE_ID,
6720: l_budget_version_id_tbl(i),