APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_RESOURCE_ASGN_CURR

Line 3316: DELETE pa_resource_asgn_curr_tmp;

3312:
3313: IF l_ra_id_tab_table(i).count > 0 AND
3314: l_planning_options_flag_tab(i) = 'Y' THEN
3315:
3316: DELETE pa_resource_asgn_curr_tmp;
3317:
3318: -- As per the copy_table_records API specification, when calling the
3319: -- maintenance API in temp table Copy mode, populate the temp table
3320: -- with distinct target ra_id values (without txn_currency_code values).

Line 3322: INSERT INTO pa_resource_asgn_curr_tmp

3318: -- As per the copy_table_records API specification, when calling the
3319: -- maintenance API in temp table Copy mode, populate the temp table
3320: -- with distinct target ra_id values (without txn_currency_code values).
3321:
3322: INSERT INTO pa_resource_asgn_curr_tmp
3323: ( resource_assignment_id )
3324: SELECT DISTINCT column_value
3325: FROM TABLE( CAST( l_ra_id_tab_table(i) AS SYSTEM.pa_num_tbl_type ));
3326:

Line 3371: DELETE pa_resource_asgn_curr_tmp;

3367: l_non_billable_fp_ra_id_tab.count > 0 AND
3368: l_fp_cols_rec_fp.x_version_type = 'ALL' AND
3369: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3370:
3371: DELETE pa_resource_asgn_curr_tmp;
3372:
3373: -- Note: An outer join on pa_tasks is not needed in the query
3374: -- below because we are only interested in updating resources
3375: -- for non-billable tasks. Project-level tasks that require an

Line 3377: INSERT INTO pa_resource_asgn_curr_tmp

3373: -- Note: An outer join on pa_tasks is not needed in the query
3374: -- below because we are only interested in updating resources
3375: -- for non-billable tasks. Project-level tasks that require an
3376: -- outer join are always billable.
3377: INSERT INTO pa_resource_asgn_curr_tmp
3378: ( RESOURCE_ASSIGNMENT_ID,
3379: TXN_CURRENCY_CODE,
3380: TXN_RAW_COST_RATE_OVERRIDE,
3381: TXN_BURDEN_COST_RATE_OVERRIDE )

Line 3386: FROM pa_resource_asgn_curr rbc

3382: SELECT rbc.resource_assignment_id,
3383: rbc.txn_currency_code,
3384: rbc.txn_raw_cost_rate_override,
3385: rbc.txn_burden_cost_rate_override
3386: FROM pa_resource_asgn_curr rbc
3387: WHERE rbc.budget_version_id = p_budget_version_id
3388: AND rbc.txn_bill_rate_override IS NOT NULL
3389: AND EXISTS ( SELECT null
3390: FROM TABLE(CAST( l_non_billable_fp_ra_id_tab AS SYSTEM.pa_num_tbl_type ))

Line 3426: END IF; -- logic to copy source pa_resource_asgn_curr overrides

3422: END IF;
3423: END IF; -- IF l_count > 0 THEN
3424: END IF; -- logic to null out bill rate overrides for non-billable tasks
3425:
3426: END IF; -- logic to copy source pa_resource_asgn_curr overrides
3427: -- END OF IPM: New Entity ER ------------------------------------------
3428:
3429:
3430: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN