APPS.PA_ALLOC_RUN dependencies on PA_PROJECTS_ALL

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

1962: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;
1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1964: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1965: else
1966: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1967: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1968: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1969: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1970: if p_limit_target_projects_code = 'L' then

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

1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;
1964: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1965: else
1966: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1967: l_from_str2 := ' From pa_tasks pt, pa_cross_chargeable_ou_v pcou, pa_projects_all pp ' ;
1968: --l_where_str0 := ' where pp.project_id = pt.project_id AND nvl(pp.org_id,''0'') = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1969: l_where_str0 := ' where pp.project_id = pt.project_id AND pp.org_id = nvl(pcou.recvr_org_id, ''0'') AND ' ;
1970: if p_limit_target_projects_code = 'L' then
1971: l_where_str0 := l_where_str0 || 'pcou.prvdr_legal_entity_id = pcou.recvr_legal_entity_id AND ' ;

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

8476: +nvl(pta.i_tot_labor_hours,0),
8477: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
8478: +nvl(pta.i_tot_quantity,0),
8479: 0 )) AMOUNT
8480: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8481: 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 */
8482: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8483: pa_periods pp
8484: -- pa_projects_all p ,

Line 8484: -- pa_projects_all p ,

8480: /* Rearranged the tables in the FROM clause and commented out pa_projects_all for bug 2751178 */
8481: 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 */
8482: pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta, */
8483: pa_periods pp
8484: -- pa_projects_all p ,
8485: where /* Bug 3749469
8486: part.rule_id = p_rule_id
8487: and part.run_id = p_run_id
8488: and part.exclude_flag = 'N'

Line 8537: pa_projects_all p ,

8533: 0
8534: ))
8535: /*** from pa_base_budget_by_pa_period_v pbpp, *** commented bug 2619977 */
8536: from pa_base_finplan_by_pa_period_v pfpp, /* added bug 2619977 */
8537: pa_projects_all p ,
8538: pa_alloc_run_targets part
8539: where part.rule_id = p_rule_id
8540: and part.run_id = p_run_id
8541: and part.exclude_flag = 'N'

Line 9643: , pa_projects_all pp

9639: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9640: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9641: /* end of performance changes */
9642: from pa_alloc_txn_details patd
9643: , pa_projects_all pp
9644: , pa_tasks pt
9645: where patd.run_id = p_run_id
9646: and patd.project_id = pp.project_id
9647: and patd.task_id = pt.task_id ;