DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_FP_ROLLUP_TMP

Line 832: delete from pa_fp_rollup_tmp;

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,

Line 833: insert into pa_fp_rollup_tmp(

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,

Line 870: FROM Pa_Fp_Rollup_Tmp

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 */