eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 3739: DELETE pa_resource_asgn_curr_tmp;

3735: END IF;
3736:
3737: ELSIF l_fp_cols_rec_target.x_gen_ret_manual_line_flag = 'Y' THEN
3738:
3739: DELETE pa_resource_asgn_curr_tmp;
3740:
3741: -- Note that while (txn_resource_assignment_id, txn_currency_code) pairs
3742: -- should be distinct in pa_res_list_map_tmp4 because of the one-to-one
3743: -- source/target mapping, (txn_resource_assignment_id) by itself is not

Line 3751: INSERT INTO pa_resource_asgn_curr_tmp

3747: -- Also, as per the copy_table_records API specification, when calling
3748: -- the maintenance API in temp table Copy mode, only target ra_id values
3749: -- should be populated in the temp table.
3750:
3751: INSERT INTO pa_resource_asgn_curr_tmp
3752: ( resource_assignment_id )
3753: SELECT DISTINCT txn_resource_assignment_id
3754: FROM pa_res_list_map_tmp4;
3755:

Line 3796: DELETE pa_resource_asgn_curr_tmp;

3792:
3793: IF l_fp_cols_rec_source.x_version_type = 'ALL' AND
3794: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3795:
3796: DELETE pa_resource_asgn_curr_tmp;
3797:
3798: -- Note: An outer join on pa_tasks is not needed in the query
3799: -- below because we are only interested in updating resources
3800: -- for non-billable tasks. Project-level tasks that require an

Line 3802: INSERT INTO pa_resource_asgn_curr_tmp

3798: -- Note: An outer join on pa_tasks is not needed in the query
3799: -- below because we are only interested in updating resources
3800: -- for non-billable tasks. Project-level tasks that require an
3801: -- outer join are always billable.
3802: INSERT INTO pa_resource_asgn_curr_tmp
3803: ( RESOURCE_ASSIGNMENT_ID,
3804: TXN_CURRENCY_CODE,
3805: TXN_RAW_COST_RATE_OVERRIDE,
3806: TXN_BURDEN_COST_RATE_OVERRIDE )

Line 5536: DELETE pa_resource_asgn_curr_tmp;

5532: ELSIF l_calling_context = lc_ForecastGeneration THEN
5533: l_calling_module := 'FORECAST_GENERATION';
5534: END IF;
5535:
5536: DELETE pa_resource_asgn_curr_tmp;
5537:
5538: INSERT INTO pa_resource_asgn_curr_tmp
5539: ( resource_assignment_id,
5540: txn_currency_code,

Line 5538: INSERT INTO pa_resource_asgn_curr_tmp

5534: END IF;
5535:
5536: DELETE pa_resource_asgn_curr_tmp;
5537:
5538: INSERT INTO pa_resource_asgn_curr_tmp
5539: ( resource_assignment_id,
5540: txn_currency_code,
5541: txn_raw_cost_rate_override,
5542: txn_burden_cost_rate_override,