APPS.PA_ALLOC_RUN dependencies on PA_PROJECTS_ALL

Line 1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

1952: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1954: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1955: else
1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1958: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1959: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1960: if p_limit_target_projects_code = 'L' then

Line 1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;

1953: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1954: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1955: else
1956: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1957: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1958: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1959: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1960: if p_limit_target_projects_code = 'L' then
1961: l_where_str0 := l_where_str0 || 'pcou.prvdr_legal_entity_id = pcou.recvr_legal_entity_id AND ' ;

Line 8375: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */

8371: +nvl(pta.i_tot_labor_hours,0),
8372: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8373: +nvl(pta.i_tot_quantity,0),
8374: 0 )) AMOUNT
8375: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8376: from /* pa_alloc_run_targets part, */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8377: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8378: pa_periods pp
8379: -- pa_projects_all p ,

Line 8379: -- pa_projects_all p ,

8375: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8376: from /* pa_alloc_run_targets part, */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
8377: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8378: pa_periods pp
8379: -- pa_projects_all p ,
8380: where /* Bug 3749469
8381: part.rule_id = p_rule_id
8382: and part.run_id = p_run_id
8383: and part.exclude_flag = 'N'

Line 8432: pa_projects_all p ,

8428: 0
8429: ))
8430: /*** from pa_base_budget_by_pa_period_v pbpp, *** commented bug 2619977 */
8431: from pa_base_finplan_by_pa_period_v pfpp, /* added bug 2619977 */
8432: pa_projects_all p ,
8433: pa_alloc_run_targets part
8434: where part.rule_id = p_rule_id
8435: and part.run_id = p_run_id
8436: and part.exclude_flag = 'N'

Line 9538: , pa_projects_all pp

9534: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9535: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9536: /* end of performance changes */
9537: from pa_alloc_txn_details patd
9538: , pa_projects_all pp
9539: , pa_tasks pt
9540: where patd.run_id = p_run_id
9541: and patd.project_id = pp.project_id
9542: and patd.task_id = pt.task_id ;