DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 8662: DELETE pa_resource_asgn_curr_tmp;

8658: pa_debug.g_err_stage := 'l_def_txn_curr_code: ' || l_def_txn_curr_code;
8659: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8660: END IF;
8661:
8662: DELETE pa_resource_asgn_curr_tmp;
8663: /* bulk insert the left over resource assignments into the new table with default txn currency
8664: * derived above */
8665: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8666: INSERT INTO pa_resource_asgn_curr_tmp

Line 8666: INSERT INTO pa_resource_asgn_curr_tmp

8662: DELETE pa_resource_asgn_curr_tmp;
8663: /* bulk insert the left over resource assignments into the new table with default txn currency
8664: * derived above */
8665: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8666: INSERT INTO pa_resource_asgn_curr_tmp
8667: (RA_TXN_ID,
8668: BUDGET_VERSION_ID,
8669: RESOURCE_ASSIGNMENT_ID,
8670: TXN_CURRENCY_CODE)