DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 1115: DELETE pa_resource_asgn_curr_tmp;

1111: -- before the Calculate API is called since actuals and planned
1112: -- amounts exist in the same budget line in this case.
1113: IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1114:
1115: DELETE pa_resource_asgn_curr_tmp;
1116:
1117: FORALL i IN 1..l_res_asg_id_tab.count
1118: INSERT INTO pa_resource_asgn_curr_tmp (
1119: resource_assignment_id,

Line 1118: INSERT INTO pa_resource_asgn_curr_tmp (

1114:
1115: DELETE pa_resource_asgn_curr_tmp;
1116:
1117: FORALL i IN 1..l_res_asg_id_tab.count
1118: INSERT INTO pa_resource_asgn_curr_tmp (
1119: resource_assignment_id,
1120: txn_currency_code )
1121: VALUES (
1122: l_res_asg_id_tab(i),

Line 1125: UPDATE pa_resource_asgn_curr_tmp tmp

1121: VALUES (
1122: l_res_asg_id_tab(i),
1123: l_txn_currency_code_tab(i) );
1124:
1125: UPDATE pa_resource_asgn_curr_tmp tmp
1126: SET ( txn_raw_cost_rate_override,
1127: txn_burden_cost_rate_override,
1128: txn_bill_rate_override ) =
1129: ( SELECT rbc.txn_raw_cost_rate_override,