APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_TXN_CURRENCIES

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

5876:
5877:
5878: /******************************************************************************
5879: This api is called in calculate flow to add the currencies in budget lines
5880: table for a budget version as txn currencies in pa_fp_txn_currencies table
5881:
5882: AUG 10 2004 Raja Bug 3815266
5883: Re-written the entire code to take care of both finplan
5884: and workplan contexts. Previously refresh_wp_settings

Line 6033: FROM PA_FP_TXN_CURRENCIES TC

6029: FROM PA_BUDGET_LINES BL
6030: WHERE BL.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
6031: AND NOT EXISTS
6032: (SELECT 1
6033: FROM PA_FP_TXN_CURRENCIES TC
6034: WHERE TC.proj_fp_options_id = l_proj_fp_options_id_tbl(i) AND
6035: TC.txn_currency_code = BL.txn_currency_code);
6036:
6037: FORALL j IN 1..l_txn_curr_code_tab.count

Line 6038: INSERT INTO PA_FP_TXN_CURRENCIES

6034: WHERE TC.proj_fp_options_id = l_proj_fp_options_id_tbl(i) AND
6035: TC.txn_currency_code = BL.txn_currency_code);
6036:
6037: FORALL j IN 1..l_txn_curr_code_tab.count
6038: INSERT INTO PA_FP_TXN_CURRENCIES
6039: (
6040: FP_TXN_CURRENCY_ID,
6041: PROJ_FP_OPTIONS_ID,
6042: PROJECT_ID,

Line 6059: PA_FP_TXN_CURRENCIES_S.NEXTVAL,

6055: LAST_UPDATE_DATE
6056: )
6057: VALUES
6058: (
6059: PA_FP_TXN_CURRENCIES_S.NEXTVAL,
6060: l_proj_fp_options_id_tbl(i),
6061: l_fp_cols_rec.X_PROJECT_ID,
6062: l_fp_cols_rec.X_FIN_PLAN_TYPE_ID,
6063: l_budget_version_id_tbl(i),