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_FP_VIEW_PLANS_PUB dependencies on PA_FIN_VP_PDS_VIEW_TMP

Line 684: DELETE from PA_FIN_VP_PDS_VIEW_TMP;

680: -- G_FP_ALL_VERSION_NUMBER
681: --hr_utility.trace('calling view_plan_temp_tables');
682: -- delete residual data in the temp tables
683: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;
684: DELETE from PA_FIN_VP_PDS_VIEW_TMP;
685: pa_fp_view_plans_pub.view_plan_temp_tables
686: (p_project_id => l_project_id,
687: p_budget_version_id => p_orgfcst_version_id,
688: p_cost_or_revenue => l_cost_or_revenue,

Line 728: DELETE FROM pa_fin_vp_pds_view_tmp tmp1

724: DELETE FROM pa_fin_vp_amts_view_tmp
725: WHERE project_id=l_project_id AND
726: resource_list_member_id > 0;
727:
728: DELETE FROM pa_fin_vp_pds_view_tmp tmp1
729: WHERE tmp1.project_id=l_project_id AND
730: tmp1.resource_list_member_id = 0
731: and exists (select 1 from pa_fin_vp_pds_view_tmp tmp2
732: where tmp2.task_id=tmp1.task_id

Line 731: and exists (select 1 from pa_fin_vp_pds_view_tmp tmp2

727:
728: DELETE FROM pa_fin_vp_pds_view_tmp tmp1
729: WHERE tmp1.project_id=l_project_id AND
730: tmp1.resource_list_member_id = 0
731: and exists (select 1 from pa_fin_vp_pds_view_tmp tmp2
732: where tmp2.task_id=tmp1.task_id
733: and tmp2.resource_list_member_id>0);
734: END IF;
735: --End Bug 8463760

Line 1964: DELETE from PA_FIN_VP_PDS_VIEW_TMP;

1960: -- G_FP_ALL_VERSION_NUMBER
1961: --hr_utility.trace('calling view_plan_temp_tables');
1962: -- delete residual data in the temp tables
1963: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;
1964: DELETE from PA_FIN_VP_PDS_VIEW_TMP;
1965:
1966: /* -- since we've already found the complements, we call the appropriate
1967: * global temp table populating procedures ourselves
1968: pa_fp_view_plans_pub.view_plan_temp_tables

Line 3740: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total

3736: -- 11/21/2002 Dlai: amts view global temporary table: new column = UNIT_OF_MEASURE
3737: -- 11/25/2002 Dlai: select ra.total_plan_quantity for labor hours
3738: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
3739: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
3740: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3741: procedure pa_fp_vp_pop_tables_separate
3742: (p_project_id IN pa_budget_versions.project_id%TYPE,
3743: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3744: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 3770: select rowid, p.* from pa_fin_vp_pds_view_tmp p

3766: START WITH t.task_id = p_task_id
3767: CONNECT BY prior t.parent_task_id = t.task_id;
3768:
3769: cursor rollup_period_amt_csr is
3770: select rowid, p.* from pa_fin_vp_pds_view_tmp p
3771: order by row_level desc;
3772: /* Ends added for 13907149*/
3773:
3774: cursor av_cost_csr is

Line 6637: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP from the

6633: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD= 'A'
6634: l_err_stage := 900;
6635: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate', '700: transfer from rev pl/sql table to amts_tmp table', 1);
6636: --hr_utility.trace('total rows is ' || to_char(nvl(l_c_project_id.last,0) + nvl(l_r_project_id.last,0)));
6637: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP from the
6638: -- PERIODS PL/SQL table
6639: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
6640: --hr_utility.trace('inserting into pa_fin_vp_pds_view_tmp for POP_TEM_TABLES_SEP');
6641: --hr_utility.trace('l_pd_project_id.last= ' || to_char(l_pd_project_id.last));

Line 6640: --hr_utility.trace('inserting into pa_fin_vp_pds_view_tmp for POP_TEM_TABLES_SEP');

6636: --hr_utility.trace('total rows is ' || to_char(nvl(l_c_project_id.last,0) + nvl(l_r_project_id.last,0)));
6637: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP from the
6638: -- PERIODS PL/SQL table
6639: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
6640: --hr_utility.trace('inserting into pa_fin_vp_pds_view_tmp for POP_TEM_TABLES_SEP');
6641: --hr_utility.trace('l_pd_project_id.last= ' || to_char(l_pd_project_id.last));
6642: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
6643: insert into pa_fin_vp_pds_view_tmp
6644: (project_id,

Line 6643: insert into pa_fin_vp_pds_view_tmp

6639: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
6640: --hr_utility.trace('inserting into pa_fin_vp_pds_view_tmp for POP_TEM_TABLES_SEP');
6641: --hr_utility.trace('l_pd_project_id.last= ' || to_char(l_pd_project_id.last));
6642: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
6643: insert into pa_fin_vp_pds_view_tmp
6644: (project_id,
6645: task_id,
6646: resource_list_member_id,
6647: uom,

Line 6755: from pa_fin_vp_pds_view_tmp

6751: t_period_amount10,
6752: t_period_amount11,
6753: t_period_amount12,
6754: t_period_amount13
6755: from pa_fin_vp_pds_view_tmp
6756: where rowid = rollup_rec.rowid;
6757:
6758: if (rollup_rec.element_name is not null) then
6759: update pa_fin_vp_pds_view_tmp p

Line 6759: update pa_fin_vp_pds_view_tmp p

6755: from pa_fin_vp_pds_view_tmp
6756: where rowid = rollup_rec.rowid;
6757:
6758: if (rollup_rec.element_name is not null) then
6759: update pa_fin_vp_pds_view_tmp p
6760: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
6761: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
6762: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
6763: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 6779: update pa_fin_vp_pds_view_tmp p

6775: and rollup_rec.element_name is not null
6776: and p.element_name = rollup_rec.parent_element_name
6777: and p.element_name is not null;
6778: else
6779: update pa_fin_vp_pds_view_tmp p
6780: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
6781: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
6782: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
6783: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 6799: from pa_fin_vp_pds_view_tmp p1

6795: and rollup_rec.element_name is null
6796: and p.element_name is null
6797: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
6798: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
6799: from pa_fin_vp_pds_view_tmp p1
6800: where p1.element_name = (select p2.parent_element_name from
6801: pa_fin_vp_pds_view_tmp p2
6802: where p2.row_level = rollup_rec.row_level
6803: and p2.element_name is not null

Line 6801: pa_fin_vp_pds_view_tmp p2

6797: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
6798: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
6799: from pa_fin_vp_pds_view_tmp p1
6800: where p1.element_name = (select p2.parent_element_name from
6801: pa_fin_vp_pds_view_tmp p2
6802: where p2.row_level = rollup_rec.row_level
6803: and p2.element_name is not null
6804: and p2.project_id = rollup_rec.project_id
6805: and p2.task_id = rollup_rec.task_id

Line 6845: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total

6841: -- flag='Y' for that amount type
6842: -- 11/25/2002 Dlai: select ra.total_plan_quantity for labor hours
6843: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
6844: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
6845: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
6846: procedure pa_fp_vp_pop_tables_together
6847: (p_project_id IN pa_budget_versions.project_id%TYPE,
6848: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6849: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 6872: select rowid, p.* from pa_fin_vp_pds_view_tmp p

6868: START WITH t.task_id = p_task_id
6869: CONNECT BY prior t.parent_task_id = t.task_id;
6870:
6871: cursor rollup_period_amt_csr is
6872: select rowid, p.* from pa_fin_vp_pds_view_tmp p
6873: order by row_level desc;
6874: /* Ends added for 7514054 */
6875:
6876: cursor av_csr is

Line 8067: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP from the

8063: where resource_list_member_id = 0;
8064: commit;
8065: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
8066:
8067: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP from the
8068: -- PERIODS PL/SQL table
8069: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
8070: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
8071: --hr_utility.trace('l_pd_project_id.first= ' || TO_CHAR(l_pd_project_id.first));

Line 8074: insert into pa_fin_vp_pds_view_tmp

8070: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
8071: --hr_utility.trace('l_pd_project_id.first= ' || TO_CHAR(l_pd_project_id.first));
8072: --hr_utility.trace('l_pd_project_id.last= ' || TO_CHAR(l_pd_project_id.last));
8073: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
8074: insert into pa_fin_vp_pds_view_tmp
8075: (project_id,
8076: task_id,
8077: resource_list_member_id,
8078: uom,

Line 8187: from pa_fin_vp_pds_view_tmp

8183: t_period_amount10,
8184: t_period_amount11,
8185: t_period_amount12,
8186: t_period_amount13
8187: from pa_fin_vp_pds_view_tmp
8188: where rowid = rollup_rec.rowid;
8189:
8190: if (rollup_rec.element_name is not null) then
8191: update pa_fin_vp_pds_view_tmp p

Line 8191: update pa_fin_vp_pds_view_tmp p

8187: from pa_fin_vp_pds_view_tmp
8188: where rowid = rollup_rec.rowid;
8189:
8190: if (rollup_rec.element_name is not null) then
8191: update pa_fin_vp_pds_view_tmp p
8192: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
8193: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
8194: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
8195: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 8211: update pa_fin_vp_pds_view_tmp p

8207: and rollup_rec.element_name is not null
8208: and p.element_name = rollup_rec.parent_element_name
8209: and p.element_name is not null;
8210: else
8211: update pa_fin_vp_pds_view_tmp p
8212: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
8213: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
8214: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
8215: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 8231: from pa_fin_vp_pds_view_tmp p1

8227: and rollup_rec.element_name is null
8228: and p.element_name is null
8229: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
8230: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
8231: from pa_fin_vp_pds_view_tmp p1
8232: where p1.element_name = (select p2.parent_element_name from
8233: pa_fin_vp_pds_view_tmp p2
8234: where p2.row_level = rollup_rec.row_level
8235: and p2.element_name is not null

Line 8233: pa_fin_vp_pds_view_tmp p2

8229: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
8230: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
8231: from pa_fin_vp_pds_view_tmp p1
8232: where p1.element_name = (select p2.parent_element_name from
8233: pa_fin_vp_pds_view_tmp p2
8234: where p2.row_level = rollup_rec.row_level
8235: and p2.element_name is not null
8236: and p2.project_id = rollup_rec.project_id
8237: and p2.task_id = rollup_rec.task_id

Line 8280: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total

8276: -- flag='Y' for that amount type
8277: -- 11/25/2002 Dlai: for labor_hrs column, query ra.total_plan_quantity
8278: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
8279: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
8280: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
8281: -- 10/07/2003 Dlai: added l_pd_project_total(l_row_number) := null for Margin row
8282: procedure pa_fp_vp_pop_tables_single
8283: (p_project_id IN pa_budget_versions.project_id%TYPE,
8284: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 8310: select rowid, p.* from pa_fin_vp_pds_view_tmp p

8306: CONNECT BY prior t.parent_task_id = t.task_id;
8307:
8308:
8309: cursor rollup_period_amt_csr is
8310: select rowid, p.* from pa_fin_vp_pds_view_tmp p
8311: order by row_level desc;
8312:
8313: /* Ends added for bug 7514054 */
8314:

Line 9441: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP

9437: end if; --pa_fp_view_plans_pub.G_AMT_OR_PD= 'A'
9438: l_err_stage := 500;
9439: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_single', '800: amts temp table populated', 1);
9440:
9441: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP
9442: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
9443: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
9444: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
9445: insert into pa_fin_vp_pds_view_tmp

Line 9445: insert into pa_fin_vp_pds_view_tmp

9441: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP
9442: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
9443: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
9444: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
9445: insert into pa_fin_vp_pds_view_tmp
9446: (project_id,
9447: task_id,
9448: resource_list_member_id,
9449: uom,

Line 9559: from pa_fin_vp_pds_view_tmp

9555: t_period_amount10,
9556: t_period_amount11,
9557: t_period_amount12,
9558: t_period_amount13
9559: from pa_fin_vp_pds_view_tmp
9560: where rowid = rollup_rec.rowid;
9561:
9562: if (rollup_rec.element_name is not null) then
9563: update pa_fin_vp_pds_view_tmp p

Line 9563: update pa_fin_vp_pds_view_tmp p

9559: from pa_fin_vp_pds_view_tmp
9560: where rowid = rollup_rec.rowid;
9561:
9562: if (rollup_rec.element_name is not null) then
9563: update pa_fin_vp_pds_view_tmp p
9564: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
9565: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
9566: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
9567: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 9583: update pa_fin_vp_pds_view_tmp p

9579: and rollup_rec.element_name is not null
9580: and p.element_name = rollup_rec.parent_element_name
9581: and p.element_name is not null;
9582: else
9583: update pa_fin_vp_pds_view_tmp p
9584: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
9585: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
9586: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
9587: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 9603: from pa_fin_vp_pds_view_tmp p1

9599: and rollup_rec.element_name is null
9600: and p.element_name is null
9601: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
9602: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
9603: from pa_fin_vp_pds_view_tmp p1
9604: where p1.element_name = (select p2.parent_element_name from
9605: pa_fin_vp_pds_view_tmp p2
9606: where p2.row_level = rollup_rec.row_level
9607: and p2.element_name is not null

Line 9605: pa_fin_vp_pds_view_tmp p2

9601: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
9602: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
9603: from pa_fin_vp_pds_view_tmp p1
9604: where p1.element_name = (select p2.parent_element_name from
9605: pa_fin_vp_pds_view_tmp p2
9606: where p2.row_level = rollup_rec.row_level
9607: and p2.element_name is not null
9608: and p2.project_id = rollup_rec.project_id
9609: and p2.task_id = rollup_rec.task_id

Line 10381: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP

10377: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_single', '800: amts temp table populated', 1);
10378: --hr_utility.trace('amts temp table populated: 800');
10379: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD= 'A'
10380:
10381: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP
10382: -- only if in periodic mode
10383: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
10384: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
10385: insert into pa_fin_vp_pds_view_tmp

Line 10385: insert into pa_fin_vp_pds_view_tmp

10381: -- POPULATE global temporary table PA_FIN_VP_PDS_VIEW_TMP
10382: -- only if in periodic mode
10383: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'P' then
10384: forall z in nvl(l_pd_project_id.first,0)..nvl(l_pd_project_id.last,-1)
10385: insert into pa_fin_vp_pds_view_tmp
10386: (project_id,
10387: task_id,
10388: resource_list_member_id,
10389: uom,

Line 10500: from pa_fin_vp_pds_view_tmp

10496: t_period_amount10,
10497: t_period_amount11,
10498: t_period_amount12,
10499: t_period_amount13
10500: from pa_fin_vp_pds_view_tmp
10501: where rowid = rollup_rec.rowid;
10502:
10503: if rollup_rec.element_name is not null then
10504:

Line 10505: update pa_fin_vp_pds_view_tmp p

10501: where rowid = rollup_rec.rowid;
10502:
10503: if rollup_rec.element_name is not null then
10504:
10505: update pa_fin_vp_pds_view_tmp p
10506: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
10507: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
10508: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
10509: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 10525: update pa_fin_vp_pds_view_tmp p

10521: and rollup_rec.element_name is not null
10522: and p.element_name = rollup_rec.parent_element_name
10523: and p.element_name is not null;
10524: else
10525: update pa_fin_vp_pds_view_tmp p
10526: set p.period_amount1 = nvl(p.period_amount1, 0)+nvl(t_period_amount1,0),
10527: p.period_amount2 = nvl(p.period_amount2, 0)+nvl(t_period_amount2, 0),
10528: p.period_amount3 = nvl(p.period_amount3, 0)+nvl(t_period_amount3, 0),
10529: p.period_amount4 = nvl(p.period_amount4, 0)+nvl(t_period_amount4, 0),

Line 10545: from pa_fin_vp_pds_view_tmp p1

10541: and rollup_rec.element_name is null
10542: and p.element_name is null
10543: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
10544: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
10545: from pa_fin_vp_pds_view_tmp p1
10546: where p1.element_name = (select p2.parent_element_name from
10547: pa_fin_vp_pds_view_tmp p2
10548: where p2.row_level = rollup_rec.row_level
10549: and p2.element_name is not null

Line 10547: pa_fin_vp_pds_view_tmp p2

10543: and (p.project_id,p.task_id, p.resource_list_member_id,row_level)
10544: in (select p1.project_id, p1.task_id, p1.resource_list_member_id, p1.row_level
10545: from pa_fin_vp_pds_view_tmp p1
10546: where p1.element_name = (select p2.parent_element_name from
10547: pa_fin_vp_pds_view_tmp p2
10548: where p2.row_level = rollup_rec.row_level
10549: and p2.element_name is not null
10550: and p2.project_id = rollup_rec.project_id
10551: and p2.task_id = rollup_rec.task_id