828: l_est_projfunc_raw_cost := p_est_proj_raw_cost;
829: l_est_projfunc_bd_cost := p_est_proj_bd_cost;
830: l_est_projfunc_revenue := p_est_proj_revenue;
831: ELSE
832: delete from pa_fp_rollup_tmp;
833: insert into pa_fp_rollup_tmp(
834: RESOURCE_ASSIGNMENT_ID,
835: START_DATE,
836: END_DATE,
829: l_est_projfunc_bd_cost := p_est_proj_bd_cost;
830: l_est_projfunc_revenue := p_est_proj_revenue;
831: ELSE
832: delete from pa_fp_rollup_tmp;
833: insert into pa_fp_rollup_tmp(
834: RESOURCE_ASSIGNMENT_ID,
835: START_DATE,
836: END_DATE,
837: TXN_CURRENCY_CODE,
866: INTO
867: l_est_projfunc_raw_cost ,
868: l_est_projfunc_bd_cost ,
869: l_est_projfunc_revenue
870: FROM Pa_Fp_Rollup_Tmp
871: WHERE RESOURCE_ASSIGNMENT_ID = -1;
872:
873: END IF;
874: /* for proj curr code equal to projfunc curr code chk */