DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_RESOURCE_ASGN_CURR

Line 5027: DELETE pa_resource_asgn_curr_tmp;

5023: END IF; -- l_copy_lines = 'NONE'
5024:
5025: -- Processing for pa_res_curr table:
5026:
5027: DELETE pa_resource_asgn_curr_tmp;
5028:
5029: INSERT INTO pa_resource_asgn_curr_tmp
5030: ( resource_assignment_id,
5031: txn_currency_code,

Line 5029: INSERT INTO pa_resource_asgn_curr_tmp

5025: -- Processing for pa_res_curr table:
5026:
5027: DELETE pa_resource_asgn_curr_tmp;
5028:
5029: INSERT INTO pa_resource_asgn_curr_tmp
5030: ( resource_assignment_id,
5031: txn_currency_code,
5032: txn_raw_cost_rate_override,
5033: txn_burden_cost_rate_override,

Line 5043: pa_resource_asgn_curr rbc,

5039: rbc.txn_burden_cost_rate_override,
5040: rbc.txn_bill_rate_override
5041: FROM pa_resource_assignments ra,
5042: pa_budget_lines bl,
5043: pa_resource_asgn_curr rbc,
5044: PA_FP_CALC_AMT_TMP2 tmp4
5045: WHERE ra.budget_version_id = P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID
5046: AND ra.project_id = P_FP_COLS_TGT_REC.x_project_id
5047: AND ra.resource_assignment_id = tmp4.target_res_asg_id