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.

[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_PROJECTS

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

1209: || ' (select pt1.task_id FROM pa_tasks pt1 '
1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1212: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1216: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;

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

1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1212: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1216: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;
1218: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;

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

1948: l_billable_str := ' pt.billable_flag = :lp_billable_only_flag ' ;
1949: 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) ' ;
1950: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1951: if p_limit_target_projects_code = 'O' then
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 ' ;

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

1949: 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) ' ;
1950: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1951: if p_limit_target_projects_code = 'O' then
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 ' ;

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

5415: and Nvl(p_resource_struct_type,'RL') = 'RBS'
5416: ;
5417: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
5418: select start_date
5419: from pa_projects
5420: where project_id = p_proj_id;
5421: v_project_start_date PA_PROJECTS.START_DATE%TYPE ; Commented for bug 2757875 ****/
5422: v_commit_count NUMBER;
5423: BEGIN

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

5417: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
5418: select start_date
5419: from pa_projects
5420: where project_id = p_proj_id;
5421: v_project_start_date PA_PROJECTS.START_DATE%TYPE ; Commented for bug 2757875 ****/
5422: v_commit_count NUMBER;
5423: BEGIN
5424: -- project and task amount are inserted based on the amount type (FTYD/QTD/PTD/ITD)
5425: -- and run period and run period type

Line 6148: from pa_projects

6144: from pa_alloc_rules_all
6145: where rule_id = p_rule_id;
6146: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
6147: select start_date
6148: from pa_projects
6149: where project_id = p_proj_id;
6150: v_project_start_date PA_PROJECTS.START_DATE%TYPE ;
6151: **** Commented for bug 2757875 ****/
6152: v_commit_count NUMBER;

Line 6150: v_project_start_date PA_PROJECTS.START_DATE%TYPE ;

6146: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
6147: select start_date
6148: from pa_projects
6149: where project_id = p_proj_id;
6150: v_project_start_date PA_PROJECTS.START_DATE%TYPE ;
6151: **** Commented for bug 2757875 ****/
6152: v_commit_count NUMBER;
6153: v_rule_pool_percent NUMBER; /* Added for bug 3227783 */
6154: BEGIN

Line 7226: from pa_projects

7222: and pp.end_date >= v_project_start_date
7223: and pp.end_date <= p_run_period_end_date ;
7224: Cursor C_proj_start_date is
7225: select start_date
7226: from pa_projects
7227: where project_id = p_project_id ;
7228: BEGIN
7229: -- project and task amount is returned based on the amount type (FTYD/QTD/PTD/ITD)
7230: -- and run period and run period type

Line 7735: pa_projects P

7731: +nvl(pta.i_tot_burdened_cost,0),
7732: 0) * v_pool_percent ) )
7733: from pa_alloc_txn_accum_v pta, /* FP.M : Allocation Impact : pa_txn_accum pta */
7734: pa_periods pp ,
7735: pa_projects P
7736: /* 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 */
7737: where /* pars.rule_id = p_rule_id
7738: and pars.run_id = p_run_id
7739: and pars.exclude_flag = 'N'

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 ;