APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 1074: DELETE pa_resource_asgn_curr_tmp;

1070: -- before the Calculate API is called since actuals and planned
1071: -- amounts exist in the same budget line in this case.
1072: IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1073:
1074: DELETE pa_resource_asgn_curr_tmp;
1075:
1076: FORALL i IN 1..l_res_asg_id_tab.count
1077: INSERT INTO pa_resource_asgn_curr_tmp (
1078: resource_assignment_id,

Line 1077: INSERT INTO pa_resource_asgn_curr_tmp (

1073:
1074: DELETE pa_resource_asgn_curr_tmp;
1075:
1076: FORALL i IN 1..l_res_asg_id_tab.count
1077: INSERT INTO pa_resource_asgn_curr_tmp (
1078: resource_assignment_id,
1079: txn_currency_code )
1080: VALUES (
1081: l_res_asg_id_tab(i),

Line 1084: UPDATE pa_resource_asgn_curr_tmp tmp

1080: VALUES (
1081: l_res_asg_id_tab(i),
1082: l_txn_currency_code_tab(i) );
1083:
1084: UPDATE pa_resource_asgn_curr_tmp tmp
1085: SET ( txn_raw_cost_rate_override,
1086: txn_burden_cost_rate_override,
1087: txn_bill_rate_override ) =
1088: ( SELECT rbc.txn_raw_cost_rate_override,