DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_RBS_PLANS_OUT_TMP

Line 5052: --Bug 3974569. Need not have pa_rbs_plans_out_tmp in the FROM clause if the parameter is N

5048: END IF;
5049:
5050: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
5051:
5052: --Bug 3974569. Need not have pa_rbs_plans_out_tmp in the FROM clause if the parameter is N
5053: IF P_PA_DEBUG_MODE = 'Y' THEN
5054: pa_debug.g_err_stage:='p_rbs_map_diff_flag '||p_rbs_map_diff_flag;
5055: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5056: END IF;

Line 5309: --For Bug 3974569. Take rbs_element_id and txn_accum_header_id from pa_rbs_plans_out_tmp

5305: ,PA_RESOURCE_ASSIGNMENTS pra
5306: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5307: AND pra.budget_version_id = p_source_plan_version_id ;
5308:
5309: --For Bug 3974569. Take rbs_element_id and txn_accum_header_id from pa_rbs_plans_out_tmp
5310: ELSIF p_rbs_map_diff_flag ='Y' THEN --IF p_rbs_map_diff_flag ='N' THEN
5311:
5312: IF P_PA_DEBUG_MODE = 'Y' THEN
5313:

Line 5323: FROM pa_rbs_plans_out_tmp;

5319: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5320:
5321: SELECT COUNT(*)
5322: INTO l_tmp
5323: FROM pa_rbs_plans_out_tmp;
5324:
5325: pa_debug.g_err_stage:='pa_rbs_plans_out_tmp count '||l_tmp;
5326: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5327:

Line 5325: pa_debug.g_err_stage:='pa_rbs_plans_out_tmp count '||l_tmp;

5321: SELECT COUNT(*)
5322: INTO l_tmp
5323: FROM pa_rbs_plans_out_tmp;
5324:
5325: pa_debug.g_err_stage:='pa_rbs_plans_out_tmp count '||l_tmp;
5326: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5327:
5328: END IF;
5329:

Line 5576: ,pa_rbs_plans_out_tmp rmap

5572: ,scheduled_delay --For Bug 3948128
5573: ,pra.CBS_ELEMENT_ID -- bug#16200605
5574: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5575: ,PA_RESOURCE_ASSIGNMENTS pra
5576: ,pa_rbs_plans_out_tmp rmap
5577: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5578: AND pra.budget_version_id = p_source_plan_version_id
5579: AND rmap.source_id = pra.resource_assignment_id;
5580: