APPS.PA_FIN_PLAN_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 8517: pa_resource_asgn_curr_tmp pract

8513: prac.txn_raw_cost_rate_override,
8514: prac.txn_burden_cost_rate_override,
8515: prac.txn_bill_rate_override
8516: FROM pa_resource_asgn_curr prac,
8517: pa_resource_asgn_curr_tmp pract
8518: WHERE prac.resource_assignment_id = pract.resource_assignment_id
8519: and prac.budget_version_id = pract.budget_version_id;
8520:
8521: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 8703: DELETE pa_resource_asgn_curr_tmp;

8699: pa_debug.g_err_stage := 'l_def_txn_curr_code: ' || l_def_txn_curr_code;
8700: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8701: END IF;
8702:
8703: DELETE pa_resource_asgn_curr_tmp;
8704: /* bulk insert the left over resource assignments into the new table with default txn currency
8705: * derived above */
8706: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8707: INSERT INTO pa_resource_asgn_curr_tmp

Line 8707: INSERT INTO pa_resource_asgn_curr_tmp

8703: DELETE pa_resource_asgn_curr_tmp;
8704: /* bulk insert the left over resource assignments into the new table with default txn currency
8705: * derived above */
8706: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8707: INSERT INTO pa_resource_asgn_curr_tmp
8708: (RA_TXN_ID,
8709: BUDGET_VERSION_ID,
8710: RESOURCE_ASSIGNMENT_ID,
8711: TXN_CURRENCY_CODE,

Line 8734: UPDATE pa_resource_asgn_curr_tmp

8730: CLOSE rate_update_cur;
8731:
8732: IF l_res_assignment_id_tbl.COUNT > 0 THEN
8733: FORALL i in l_res_assignment_id_tbl.FIRST .. l_res_assignment_id_tbl.LAST
8734: UPDATE pa_resource_asgn_curr_tmp
8735: SET txn_raw_cost_rate_override = l_raw_cost_rate_ovr_tbl(i),
8736: txn_burden_cost_rate_override = l_burd_cost_rate_ovr_tbl(i),
8737: txn_bill_rate_override = l_bill_rate_ovr_tbl(i)
8738: WHERE resource_assignment_id = l_res_assignment_id_tbl(i);