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

Line 3661: DELETE pa_resource_asgn_curr_tmp;

3657: END IF;
3658:
3659: ELSIF l_fp_cols_rec_target.x_gen_ret_manual_line_flag = 'Y' THEN
3660:
3661: DELETE pa_resource_asgn_curr_tmp;
3662:
3663: -- Note that while (txn_resource_assignment_id, txn_currency_code) pairs
3664: -- should be distinct in pa_res_list_map_tmp4 because of the one-to-one
3665: -- source/target mapping, (txn_resource_assignment_id) by itself is not

Line 3673: INSERT INTO pa_resource_asgn_curr_tmp

3669: -- Also, as per the copy_table_records API specification, when calling
3670: -- the maintenance API in temp table Copy mode, only target ra_id values
3671: -- should be populated in the temp table.
3672:
3673: INSERT INTO pa_resource_asgn_curr_tmp
3674: ( resource_assignment_id )
3675: SELECT DISTINCT txn_resource_assignment_id
3676: FROM pa_res_list_map_tmp4;
3677:

Line 3718: DELETE pa_resource_asgn_curr_tmp;

3714:
3715: IF l_fp_cols_rec_source.x_version_type = 'ALL' AND
3716: l_fp_cols_rec_target.x_version_type IN ('REVENUE','ALL') THEN
3717:
3718: DELETE pa_resource_asgn_curr_tmp;
3719:
3720: -- Note: An outer join on pa_tasks is not needed in the query
3721: -- below because we are only interested in updating resources
3722: -- for non-billable tasks. Project-level tasks that require an

Line 3724: INSERT INTO pa_resource_asgn_curr_tmp

3720: -- Note: An outer join on pa_tasks is not needed in the query
3721: -- below because we are only interested in updating resources
3722: -- for non-billable tasks. Project-level tasks that require an
3723: -- outer join are always billable.
3724: INSERT INTO pa_resource_asgn_curr_tmp
3725: ( RESOURCE_ASSIGNMENT_ID,
3726: TXN_CURRENCY_CODE,
3727: TXN_RAW_COST_RATE_OVERRIDE,
3728: TXN_BURDEN_COST_RATE_OVERRIDE )

Line 3733: FROM pa_resource_asgn_curr rbc

3729: SELECT rbc.resource_assignment_id,
3730: rbc.txn_currency_code,
3731: rbc.txn_raw_cost_rate_override,
3732: rbc.txn_burden_cost_rate_override
3733: FROM pa_resource_asgn_curr rbc
3734: WHERE rbc.budget_version_id = p_target_bv_id
3735: AND rbc.txn_bill_rate_override IS NOT NULL
3736: AND EXISTS ( SELECT null
3737: FROM pa_res_list_map_tmp4 tmp4,

Line 5457: DELETE pa_resource_asgn_curr_tmp;

5453: ELSIF l_calling_context = lc_ForecastGeneration THEN
5454: l_calling_module := 'FORECAST_GENERATION';
5455: END IF;
5456:
5457: DELETE pa_resource_asgn_curr_tmp;
5458:
5459: INSERT INTO pa_resource_asgn_curr_tmp
5460: ( resource_assignment_id,
5461: txn_currency_code,

Line 5459: INSERT INTO pa_resource_asgn_curr_tmp

5455: END IF;
5456:
5457: DELETE pa_resource_asgn_curr_tmp;
5458:
5459: INSERT INTO pa_resource_asgn_curr_tmp
5460: ( resource_assignment_id,
5461: txn_currency_code,
5462: txn_raw_cost_rate_override,
5463: txn_burden_cost_rate_override,

Line 5473: pa_resource_asgn_curr rbc,

5469: rbc.txn_burden_cost_rate_override,
5470: rbc.txn_bill_rate_override
5471: FROM pa_resource_assignments ra,
5472: pa_budget_lines bl,
5473: pa_resource_asgn_curr rbc,
5474: pa_res_list_map_tmp4 tmp4
5475: WHERE ra.budget_version_id = p_target_bv_id
5476: AND ra.project_id = p_project_id
5477: AND ra.resource_assignment_id = tmp4.txn_resource_assignment_id