DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_RBS_PLANS_OUT_TMP

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

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

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

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

Line 5320: FROM pa_rbs_plans_out_tmp;

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

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

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

Line 5571: ,pa_rbs_plans_out_tmp rmap

5567: ,rmap.txn_accum_header_id
5568: ,scheduled_delay --For Bug 3948128
5569: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5570: ,PA_RESOURCE_ASSIGNMENTS pra
5571: ,pa_rbs_plans_out_tmp rmap
5572: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5573: AND pra.budget_version_id = p_source_plan_version_id
5574: AND rmap.source_id = pra.resource_assignment_id;
5575: