APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

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 )