eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ALLOC_RUN dependencies on PA_PROJECTS

Line 1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;

1217: || ' (select pt1.task_id FROM pa_tasks pt1 '
1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1220: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1224: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738

Line 1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;

1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1220: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1224: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738
1226: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;

Line 1962: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp ' ;

1958: l_billable_str := ' pt.billable_flag = :lp_billable_only_flag ' ;
1959: l_expnd_item_str:= ' :p_expnd_item_date BETWEEN nvl(pt.start_date,:p_expnd_item_date) AND NVL(pt.completion_date, :p_expnd_item_date) ' ;
1960: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1961: if p_limit_target_projects_code = 'O' then
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 ' ;

Line 1963: l_from_str2 := ' From pa_tasks pt, pa_projects pp ' ;

1959: l_expnd_item_str:= ' :p_expnd_item_date BETWEEN nvl(pt.start_date,:p_expnd_item_date) AND NVL(pt.completion_date, :p_expnd_item_date) ' ;
1960: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1961: if p_limit_target_projects_code = 'O' then
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 ' ;

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 5442: from pa_projects

5438: and Nvl(p_resource_struct_type,'RL') = 'RBS'
5439: ;
5440: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
5441: select start_date
5442: from pa_projects
5443: where project_id = p_proj_id;
5444: v_project_start_date PA_PROJECTS.START_DATE%TYPE ; Commented for bug 2757875 ****/
5445: v_commit_count NUMBER;
5446: BEGIN

Line 5444: v_project_start_date PA_PROJECTS.START_DATE%TYPE ; Commented for bug 2757875 ****/

5440: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
5441: select start_date
5442: from pa_projects
5443: where project_id = p_proj_id;
5444: v_project_start_date PA_PROJECTS.START_DATE%TYPE ; Commented for bug 2757875 ****/
5445: v_commit_count NUMBER;
5446: BEGIN
5447: -- project and task amount are inserted based on the amount type (FTYD/QTD/PTD/ITD)
5448: -- and run period and run period type

Line 6171: from pa_projects

6167: from pa_alloc_rules_all
6168: where rule_id = p_rule_id;
6169: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
6170: select start_date
6171: from pa_projects
6172: where project_id = p_proj_id;
6173: v_project_start_date PA_PROJECTS.START_DATE%TYPE ;
6174: **** Commented for bug 2757875 ****/
6175: v_commit_count NUMBER;

Line 6173: v_project_start_date PA_PROJECTS.START_DATE%TYPE ;

6169: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
6170: select start_date
6171: from pa_projects
6172: where project_id = p_proj_id;
6173: v_project_start_date PA_PROJECTS.START_DATE%TYPE ;
6174: **** Commented for bug 2757875 ****/
6175: v_commit_count NUMBER;
6176: v_rule_pool_percent NUMBER; /* Added for bug 3227783 */
6177: BEGIN

Line 7249: from pa_projects

7245: and pp.end_date >= v_project_start_date
7246: and pp.end_date <= p_run_period_end_date ;
7247: Cursor C_proj_start_date is
7248: select start_date
7249: from pa_projects
7250: where project_id = p_project_id ;
7251: BEGIN
7252: -- project and task amount is returned based on the amount type (FTYD/QTD/PTD/ITD)
7253: -- and run period and run period type

Line 7796: pa_projects P

7792: +nvl(pta.i_tot_burdened_cost,0),
7793: 0) * v_pool_percent ) )
7794: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */
7795: pa_periods pp ,
7796: pa_projects P
7797: /* pa_alloc_run_sources pars */ /* Loop thru pa_alloc_run_sources. Bug 3749469 : Performance with pa_alloc_txn_accum_v. Filter for Project_Id and Task_Id */
7798: where /* pars.rule_id = p_rule_id
7799: and pars.run_id = p_run_id
7800: and pars.exclude_flag = 'N'

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 ;