APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 3556: DELETE pa_resource_asgn_curr_tmp;

3552:
3553: IF l_ra_id_tab_table(i).count > 0 AND
3554: l_planning_options_flag_tab(i) = 'Y' THEN
3555:
3556: DELETE pa_resource_asgn_curr_tmp;
3557:
3558: -- As per the copy_table_records API specification, when calling the
3559: -- maintenance API in temp table Copy mode, populate the temp table
3560: -- with distinct target ra_id values (without txn_currency_code values).

Line 3562: INSERT INTO pa_resource_asgn_curr_tmp

3558: -- As per the copy_table_records API specification, when calling the
3559: -- maintenance API in temp table Copy mode, populate the temp table
3560: -- with distinct target ra_id values (without txn_currency_code values).
3561:
3562: INSERT INTO pa_resource_asgn_curr_tmp
3563: ( resource_assignment_id )
3564: SELECT DISTINCT column_value
3565: FROM TABLE( CAST( l_ra_id_tab_table(i) AS SYSTEM.pa_num_tbl_type ));
3566:

Line 3611: DELETE pa_resource_asgn_curr_tmp;

3607: l_non_billable_fp_ra_id_tab.count > 0 AND
3608: l_fp_cols_rec_fp.x_version_type = 'ALL' AND
3609: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3610:
3611: DELETE pa_resource_asgn_curr_tmp;
3612:
3613: -- Note: An outer join on pa_tasks is not needed in the query
3614: -- below because we are only interested in updating resources
3615: -- for non-billable tasks. Project-level tasks that require an

Line 3617: INSERT INTO pa_resource_asgn_curr_tmp

3613: -- Note: An outer join on pa_tasks is not needed in the query
3614: -- below because we are only interested in updating resources
3615: -- for non-billable tasks. Project-level tasks that require an
3616: -- outer join are always billable.
3617: INSERT INTO pa_resource_asgn_curr_tmp
3618: ( RESOURCE_ASSIGNMENT_ID,
3619: TXN_CURRENCY_CODE,
3620: TXN_RAW_COST_RATE_OVERRIDE,
3621: TXN_BURDEN_COST_RATE_OVERRIDE )