DBA Data[Home] [Help]

APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 1257: DELETE pa_resource_asgn_curr_tmp;

1253: -- Cost and Revenue Together versions.
1254:
1255: IF p_fp_cols_rec.x_version_type = 'ALL' THEN
1256: DELETE pa_fp_rollup_tmp;
1257: DELETE pa_resource_asgn_curr_tmp;
1258:
1259: -- Use pa_fp_rollup_tmp to get DISTINCT records later.
1260: FORALL i IN 1..l_res_asg_id.count
1261: INSERT INTO pa_fp_rollup_tmp (

Line 1271: INSERT INTO pa_resource_asgn_curr_tmp (

1267:
1268: -- Populate temp table with overrides for 'revenue-only' txns.
1269: -- Note that the Select handles both budget and forecasts as
1270: -- well PA/GL-timephased and non-timephased versions.
1271: INSERT INTO pa_resource_asgn_curr_tmp (
1272: RESOURCE_ASSIGNMENT_ID,
1273: TXN_CURRENCY_CODE,
1274: TXN_RAW_COST_RATE_OVERRIDE,
1275: TXN_BURDEN_COST_RATE_OVERRIDE,