DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_FP_RA_MAP_TMP

Line 8403: FROM pa_fp_ra_map_tmp pfrmt;

8399: CURSOR c_calc_api_param_csr
8400: IS
8401: SELECT pfrmt.source_res_assignment_id
8402: ,pfrmt.target_res_assignment_id
8403: FROM pa_fp_ra_map_tmp pfrmt;
8404:
8405: c_calc_api_param_rec c_calc_api_param_csr%ROWTYPE;
8406:
8407: l_rbs_diff_flag VARCHAR2(1);

Line 8744: pa_fp_ra_map_tmp map,

8740: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
8741: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
8742: src_rbc.TXN_BILL_RATE_OVERRIDE
8743: FROM pa_resource_asgn_curr src_rbc,
8744: pa_fp_ra_map_tmp map,
8745: --pa_budget_lines bl
8746: pa_resource_assignments ra
8747: WHERE ra.budget_version_id =l_targ_budget_version_id
8748: -- AND src_rbc.budget_version_id = l_src_budget_version_id

Line 9126: ( p_source => 'PA_FP_RA_MAP_TMP'

9122: --Added the if condition for the bug 4200168
9123: IF l_pji_rollup_required = 'Y' THEN
9124:
9125: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api
9126: ( p_source => 'PA_FP_RA_MAP_TMP'
9127: ,p_budget_version_id => l_targ_budget_version_id
9128: ,x_return_status => x_return_status
9129: ,x_msg_data => x_msg_data
9130: ,x_msg_count => x_msg_count);

Line 9194: pa_fp_ra_map_tmp map,

9190: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
9191: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
9192: src_rbc.TXN_BILL_RATE_OVERRIDE
9193: FROM pa_resource_asgn_curr src_rbc,
9194: pa_fp_ra_map_tmp map,
9195: --pa_budget_lines bl
9196: pa_resource_assignments ra
9197: WHERE ra.budget_version_id =l_targ_budget_version_id
9198: -- AND src_rbc.budget_version_id = l_src_budget_version_id