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_PROGRESS_UTILS dependencies on PA_PROGRESS_ROLLUP

Line 347: from pa_progress_rollup

343:
344: ---- bug 5042445
345: CURSOR c_get_prior_percent_complete(l_task_id NUMBER, l_project_id NUMBER, l_as_of_date DATE) IS
346: select nvl(completed_percentage,eff_rollup_percent_comp)
347: from pa_progress_rollup
348: where project_id = l_project_id
349: and object_id = l_task_id
350: and object_type in ('PA_STRUCTURES', 'PA_TASKS')
351: and structure_Type = 'WORKPLAN'

Line 669: FROM pa_progress_rollup

665: l_return_date DATE;
666:
667: CURSOR c_get_max_rollup_dt IS
668: SELECT max(as_of_date)
669: FROM pa_progress_rollup
670: where project_id = X_Project_ID
671: and object_type IN ('PA_TASKS', 'PA_STRUCTURES')
672: and object_id = x_object_id
673: and structure_type = 'WORKPLAN'

Line 1022: FROM pa_progress_rollup ppr, pa_project_statuses pps

1018: BASE_PERCENT_COMPLETE, EFF_ROLLUP_PERCENT_COMP,
1019: ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE,
1020: ACTUAL_START_DATE, ACTUAL_FINISH_DATE,
1021: pps.status_icon_ind, pps.status_icon_active_ind
1022: FROM pa_progress_rollup ppr, pa_project_statuses pps
1023: WHERE object_id = p_task_id
1024: AND project_id = l_project_id
1025: AND ppr.eff_rollup_prog_stat_code = pps.project_status_code(+)
1026: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup

Line 1026: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup

1022: FROM pa_progress_rollup ppr, pa_project_statuses pps
1023: WHERE object_id = p_task_id
1024: AND project_id = l_project_id
1025: AND ppr.eff_rollup_prog_stat_code = pps.project_status_code(+)
1026: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup
1027: WHERE object_id = p_task_id and as_of_date <= p_as_of_date
1028: AND project_id = l_project_id );
1029: BEGIN
1030: --Added for performance improvements bug 2679612

Line 1601: FROM pa_progress_rollup

1597:
1598: CURSOR cur_prog_rollup_id_pub_wp
1599: IS
1600: SELECT progress_rollup_id, record_version_number
1601: FROM pa_progress_rollup
1602: WHERE object_type = p_object_type
1603: AND object_id = p_object_id
1604: AND project_id = p_project_id
1605: -- AND object_version_id = p_object_version_id

Line 1617: FROM pa_progress_rollup

1613:
1614: CURSOR cur_prog_rollup_id_work_wp
1615: IS
1616: SELECT progress_rollup_id, record_version_number
1617: FROM pa_progress_rollup
1618: WHERE object_type = p_object_type
1619: AND object_id = p_object_id
1620: AND project_id = p_project_id
1621: AND structure_type = p_structure_type

Line 1695: FROM pa_progress_rollup

1691: -- 4348710 : Added structure_type and structure_version_id joins
1692: CURSOR cur_cumla
1693: IS
1694: SELECT cumulative_work_quantity
1695: FROM pa_progress_rollup
1696: WHERE project_id = p_project_id
1697: AND object_id = p_object_id
1698: AND object_type = p_object_type
1699: AND structure_type = 'WORKPLAN'

Line 1702: FROM pa_progress_rollup

1698: AND object_type = p_object_type
1699: AND structure_type = 'WORKPLAN'
1700: AND structure_version_id is null
1701: AND as_of_date = ( SELECT max( as_of_date )
1702: FROM pa_progress_rollup
1703: WHERE project_id = p_project_id
1704: AND object_id = p_object_id
1705: AND object_type = p_object_type
1706: AND as_of_date < p_as_of_date

Line 2110: select 'X' from pa_progress_rollup

2106: AND rownum <= 1;
2107:
2108: Cursor c_prog_rollup
2109: is
2110: select 'X' from pa_progress_rollup
2111: where ( progress_status_code = p_status_code
2112: or base_progress_status_code = p_status_code
2113: or eff_rollup_prog_stat_code = p_status_code)
2114: AND rownum <= 1;

Line 2147: -- Check referense in pa_progress_rollup

2143: l_return_value := TRUE;
2144: end if;
2145: close c_percent_complete;
2146:
2147: -- Check referense in pa_progress_rollup
2148: if(NOT l_return_value) then
2149: open c_prog_rollup;
2150: fetch c_prog_rollup into l_dummy;
2151: if(c_prog_rollup%FOUND) then

Line 2368: from pa_progress_rollup

2364: if (((p_object_type = 'PA_TASKS') AND (nvl(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id ),'N') = 'N')) OR p_structure_version_id is not null) then
2365:
2366: select max(as_of_date)
2367: into l_rollup_date
2368: from pa_progress_rollup
2369: where project_id = p_project_id
2370: and object_id = p_object_id
2371: and object_type = p_object_type
2372: and structure_type = p_structure_type -- FPM Dev CR 3

Line 2379: from pa_progress_rollup

2375: ;
2376: else
2377: select max(as_of_date)
2378: into l_rollup_date
2379: from pa_progress_rollup
2380: where project_id = p_project_id
2381: and object_id = p_object_id
2382: and object_type = p_object_type
2383: and structure_type = p_structure_type -- FPM Dev CR 3

Line 2398: from pa_progress_rollup

2394:
2395: -- FPM Dev CR 6 : Commented the above code and added this new code to get the date.
2396: select max(as_of_date)
2397: into l_rollup_date
2398: from pa_progress_rollup
2399: where project_id = p_project_id
2400: and object_id = p_object_id
2401: and object_type = p_object_type
2402: and structure_type = p_structure_type

Line 2823: FROM pa_progress_rollup

2819:
2820: CURSOR cur_task_effort
2821: IS
2822: SELECT NVL( EQPMT_ACT_EFFORT_TO_DATE, 0 ) + NVL( PPL_ACT_EFFORT_TO_DATE, 0 ) + nvl(oth_quantity_to_date,0)
2823: FROM pa_progress_rollup
2824: WHERE project_id = p_project_id
2825: AND object_id = p_object_id
2826: --Commented by rtarway for BUG 3835474
2827: /*AND as_of_date = ( SELECT max(as_of_date)

Line 2828: from pa_progress_rollup

2824: WHERE project_id = p_project_id
2825: AND object_id = p_object_id
2826: --Commented by rtarway for BUG 3835474
2827: /*AND as_of_date = ( SELECT max(as_of_date)
2828: from pa_progress_rollup
2829: WHERE as_of_date < p_as_of_date
2830: AND project_id = p_project_id
2831: AND object_id = p_object_id
2832: AND object_type = p_object_type

Line 2839: from pa_progress_rollup ppr2

2835: --and proj_element_id = nvl(p_proj_element_id, p_object_id) Modified for IB4 Progress CR.
2836: )*/
2837: --Added by rtarway for BUG 3835474
2838: AND as_of_date = ( SELECT max(as_of_date)
2839: from pa_progress_rollup ppr2
2840: WHERE ppr2.as_of_date <= p_as_of_date
2841: AND ppr2.project_id = p_project_id
2842: AND ppr2.object_id = p_object_id
2843: AND ppr2.object_type = p_object_type

Line 2893: FROM pa_progress_rollup ppr

2889:
2890: CURSOR cur_task_cost
2891: IS
2892: SELECT (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0))
2893: FROM pa_progress_rollup ppr
2894: WHERE ppr.project_id = p_project_id
2895: AND ppr.object_id = p_object_id
2896: AND ppr.as_of_date = ( SELECT max(as_of_date)
2897: from pa_progress_rollup ppr2

Line 2897: from pa_progress_rollup ppr2

2893: FROM pa_progress_rollup ppr
2894: WHERE ppr.project_id = p_project_id
2895: AND ppr.object_id = p_object_id
2896: AND ppr.as_of_date = ( SELECT max(as_of_date)
2897: from pa_progress_rollup ppr2
2898: WHERE ppr2.as_of_date < p_as_of_date
2899: AND ppr2.project_id = p_project_id
2900: AND ppr2.object_id = p_object_id
2901: AND ppr2.object_type = p_object_type

Line 3660: from pa_progress_rollup ppr

3656: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3657: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
3658: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3659: into l_actual_cost
3660: from pa_progress_rollup ppr
3661: where ppr.project_id = p_project_id
3662: and ppr.object_id = p_object_id
3663: and prog_pa_period_name = p_period_name
3664: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3668: from pa_progress_rollup ppr2

3664: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3665: and ppr.structure_version_id IS NULL --bug 3802177
3666: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3667: and ppr.as_of_date = (select max(as_of_date)
3668: from pa_progress_rollup ppr2
3669: where ppr2.project_id = ppr.project_id
3670: and ppr2.object_id = ppr.object_id
3671: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3672: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3686: from pa_progress_rollup ppr

3682: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3683: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
3684: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3685: into l_prev_period_actual_cost
3686: from pa_progress_rollup ppr
3687: where ppr.project_id = p_project_id
3688: and ppr.object_id = p_object_id
3689: and ppr.structure_type = 'WORKPLAN'
3690: and ppr.structure_version_id IS NULL

Line 3693: from pa_progress_rollup ppr1

3689: and ppr.structure_type = 'WORKPLAN'
3690: and ppr.structure_version_id IS NULL
3691: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3692: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3693: from pa_progress_rollup ppr1
3694: where ppr1.project_id = ppr.project_id
3695: and ppr1.object_id = ppr.object_id
3696: and ppr1.structure_type = 'WORKPLAN'
3697: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3700: from pa_progress_rollup ppr2

3696: and ppr1.structure_type = 'WORKPLAN'
3697: and ppr1.structure_version_id IS NULL --bug 3802177
3698: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3699: and as_of_date < ( select min(as_of_date)
3700: from pa_progress_rollup ppr2
3701: where ppr2.project_id = ppr1.project_id
3702: and ppr2.object_id = ppr1.object_id
3703: and structure_type = 'WORKPLAN'
3704: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3717: from pa_progress_rollup ppr

3713: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3714: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
3715: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3716: into l_actual_cost
3717: from pa_progress_rollup ppr
3718: where ppr.project_id = p_project_id
3719: and ppr.object_id = p_object_id
3720: and prog_gl_period_name = p_period_name
3721: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3725: from pa_progress_rollup ppr2

3721: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3722: and ppr.structure_version_id IS NULL --bug 3802177
3723: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3724: and ppr.as_of_date = (select max(as_of_date)
3725: from pa_progress_rollup ppr2
3726: where ppr2.project_id = ppr.project_id
3727: and ppr2.object_id = ppr.object_id
3728: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3729: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3742: from pa_progress_rollup ppr

3738: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3739: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
3740: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3741: into l_prev_period_actual_cost
3742: from pa_progress_rollup ppr
3743: where ppr.project_id = p_project_id
3744: and ppr.object_id = p_object_id
3745: and ppr.structure_type = 'WORKPLAN'
3746: and ppr.structure_version_id IS NULL

Line 3749: from pa_progress_rollup ppr1

3745: and ppr.structure_type = 'WORKPLAN'
3746: and ppr.structure_version_id IS NULL
3747: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3748: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3749: from pa_progress_rollup ppr1
3750: where ppr1.project_id = ppr.project_id
3751: and ppr1.object_id = ppr.object_id
3752: and ppr1.structure_type = 'WORKPLAN'
3753: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3756: from pa_progress_rollup ppr2

3752: and ppr1.structure_type = 'WORKPLAN'
3753: and ppr1.structure_version_id IS NULL --bug 3802177
3754: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3755: and as_of_date < ( select min(as_of_date)
3756: from pa_progress_rollup ppr2
3757: where ppr2.project_id = ppr1.project_id
3758: and ppr2.object_id = ppr1.object_id
3759: and structure_type = 'WORKPLAN'
3760: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3772: from pa_progress_rollup ppr

3768: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3769: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
3770: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3771: into l_actual_cost
3772: from pa_progress_rollup ppr
3773: where ppr.project_id = p_project_id
3774: and ppr.object_id = p_object_id
3775: --and ppr.object_version_id = p_object_version_id
3776: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3787: from pa_progress_rollup ppr

3783: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3784: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
3785: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3786: into l_actual_cost
3787: from pa_progress_rollup ppr
3788: where ppr.project_id = p_project_id
3789: and ppr.object_id = p_object_id
3790: and ppr.structure_version_id = p_structure_version_id
3791: and structure_type = 'WORKPLAN'

Line 3807: from pa_progress_rollup ppr

3803: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3804: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
3805: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3806: into l_actual_cost
3807: from pa_progress_rollup ppr
3808: where ppr.project_id = p_project_id
3809: and ppr.object_id = p_object_id
3810: and prog_pa_period_name = p_period_name
3811: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3815: from pa_progress_rollup ppr2

3811: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3812: and ppr.structure_version_id IS NULL --bug 3802177
3813: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3814: and ppr.as_of_date = (select max(as_of_date)
3815: from pa_progress_rollup ppr2
3816: where ppr2.project_id = ppr.project_id
3817: and ppr2.object_id = ppr.object_id
3818: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3819: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3832: from pa_progress_rollup ppr

3828: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3829: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
3830: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3831: into l_prev_period_actual_cost
3832: from pa_progress_rollup ppr
3833: where ppr.project_id = p_project_id
3834: and ppr.object_id = p_object_id
3835: and ppr.structure_type = 'WORKPLAN'
3836: and ppr.structure_version_id IS NULL

Line 3839: from pa_progress_rollup ppr1

3835: and ppr.structure_type = 'WORKPLAN'
3836: and ppr.structure_version_id IS NULL
3837: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3838: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3839: from pa_progress_rollup ppr1
3840: where ppr1.project_id = ppr.project_id
3841: and ppr1.object_id = ppr.object_id
3842: and ppr1.structure_type = 'WORKPLAN'
3843: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3846: from pa_progress_rollup ppr2

3842: and ppr1.structure_type = 'WORKPLAN'
3843: and ppr1.structure_version_id IS NULL --bug 3802177
3844: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3845: and as_of_date < ( select min(as_of_date)
3846: from pa_progress_rollup ppr2
3847: where ppr2.project_id = ppr1.project_id
3848: and ppr2.object_id = ppr1.object_id
3849: and structure_type = 'WORKPLAN'
3850: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3864: from pa_progress_rollup ppr

3860: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3861: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
3862: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3863: into l_actual_cost
3864: from pa_progress_rollup ppr
3865: where ppr.project_id = p_project_id
3866: and ppr.object_id = p_object_id
3867: and prog_gl_period_name = p_period_name
3868: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3872: from pa_progress_rollup ppr2

3868: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3869: and ppr.structure_version_id IS NULL --bug 3802177
3870: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3871: and ppr.as_of_date = (select max(as_of_date)
3872: from pa_progress_rollup ppr2
3873: where ppr2.project_id = ppr.project_id
3874: and ppr2.object_id = ppr.object_id
3875: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3876: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3889: from pa_progress_rollup ppr

3885: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3886: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
3887: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3888: into l_prev_period_actual_cost
3889: from pa_progress_rollup ppr
3890: where ppr.project_id = p_project_id
3891: and ppr.object_id = p_object_id
3892: and ppr.structure_type = 'WORKPLAN'
3893: and ppr.structure_version_id IS NULL

Line 3896: from pa_progress_rollup ppr1

3892: and ppr.structure_type = 'WORKPLAN'
3893: and ppr.structure_version_id IS NULL
3894: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3895: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3896: from pa_progress_rollup ppr1
3897: where ppr1.project_id = ppr.project_id
3898: and ppr1.object_id = ppr.object_id
3899: and ppr1.structure_type = 'WORKPLAN'
3900: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3903: from pa_progress_rollup ppr2

3899: and ppr1.structure_type = 'WORKPLAN'
3900: and ppr1.structure_version_id IS NULL --bug 3802177
3901: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3902: and as_of_date < ( select min(as_of_date)
3903: from pa_progress_rollup ppr2
3904: where ppr2.project_id = ppr1.project_id
3905: and ppr2.object_id = ppr1.object_id
3906: and structure_type = 'WORKPLAN'
3907: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3919: from pa_progress_rollup ppr

3915: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3916: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
3917: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3918: into l_actual_cost
3919: from pa_progress_rollup ppr
3920: where ppr.project_id = p_project_id
3921: and ppr.object_id = p_object_id
3922: and ppr.object_version_id = p_object_version_id
3923: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3934: from pa_progress_rollup ppr

3930: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3931: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
3932: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3933: into l_actual_cost
3934: from pa_progress_rollup ppr
3935: where ppr.project_id = p_project_id
3936: and ppr.object_id = p_object_id
3937: and ppr.object_version_id = p_object_version_id
3938: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3953: from pa_progress_rollup ppr

3949: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
3950: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)
3951: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
3952: into l_actual_cost
3953: from pa_progress_rollup ppr
3954: where ppr.project_id = p_project_id
3955: and ppr.object_id = p_object_id
3956: and prog_pa_period_name = p_period_name
3957: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3961: from pa_progress_rollup ppr2

3957: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3958: and ppr.structure_version_id IS NULL --bug 3802177
3959: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3960: and ppr.as_of_date = (select max(as_of_date)
3961: from pa_progress_rollup ppr2
3962: where ppr2.project_id = ppr.project_id
3963: and ppr2.object_id = ppr.object_id
3964: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3965: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3978: from pa_progress_rollup ppr

3974: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
3975: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)
3976: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
3977: into l_prev_period_actual_cost
3978: from pa_progress_rollup ppr
3979: where ppr.project_id = p_project_id
3980: and ppr.object_id = p_object_id
3981: and ppr.structure_type = 'WORKPLAN'
3982: and ppr.structure_version_id IS NULL

Line 3985: from pa_progress_rollup ppr1

3981: and ppr.structure_type = 'WORKPLAN'
3982: and ppr.structure_version_id IS NULL
3983: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3984: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3985: from pa_progress_rollup ppr1
3986: where ppr1.project_id = ppr.project_id
3987: and ppr1.object_id = ppr.object_id
3988: and ppr1.structure_type = 'WORKPLAN'
3989: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3992: from pa_progress_rollup ppr2

3988: and ppr1.structure_type = 'WORKPLAN'
3989: and ppr1.structure_version_id IS NULL --bug 3802177
3990: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3991: and as_of_date < ( select min(as_of_date)
3992: from pa_progress_rollup ppr2
3993: where ppr2.project_id = ppr1.project_id
3994: and ppr2.object_id = ppr1.object_id
3995: and structure_type = 'WORKPLAN'
3996: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4009: from pa_progress_rollup ppr

4005: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4006: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)
4007: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4008: into l_actual_cost
4009: from pa_progress_rollup ppr
4010: where ppr.project_id = p_project_id
4011: and ppr.object_id = p_object_id
4012: and prog_gl_period_name = p_period_name
4013: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4017: from pa_progress_rollup ppr2

4013: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4014: and ppr.structure_version_id IS NULL --bug 3802177
4015: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4016: and ppr.as_of_date = (select max(as_of_date)
4017: from pa_progress_rollup ppr2
4018: where ppr2.project_id = ppr.project_id
4019: and ppr2.object_id = ppr.object_id
4020: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4021: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4034: from pa_progress_rollup ppr

4030: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4031: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)
4032: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4033: into l_prev_period_actual_cost
4034: from pa_progress_rollup ppr
4035: where ppr.project_id = p_project_id
4036: and ppr.object_id = p_object_id
4037: and ppr.structure_type = 'WORKPLAN'
4038: and ppr.structure_version_id IS NULL

Line 4041: from pa_progress_rollup ppr1

4037: and ppr.structure_type = 'WORKPLAN'
4038: and ppr.structure_version_id IS NULL
4039: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4040: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4041: from pa_progress_rollup ppr1
4042: where ppr1.project_id = ppr.project_id
4043: and ppr1.object_id = ppr.object_id
4044: and ppr1.structure_type = 'WORKPLAN'
4045: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4048: from pa_progress_rollup ppr2

4044: and ppr1.structure_type = 'WORKPLAN'
4045: and ppr1.structure_version_id IS NULL --bug 3802177
4046: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4047: and as_of_date < ( select min(as_of_date)
4048: from pa_progress_rollup ppr2
4049: where ppr2.project_id = ppr1.project_id
4050: and ppr2.object_id = ppr1.object_id
4051: and structure_type = 'WORKPLAN'
4052: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4064: from pa_progress_rollup ppr

4060: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4061: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)
4062: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4063: into l_actual_cost
4064: from pa_progress_rollup ppr
4065: where ppr.project_id = p_project_id
4066: and ppr.object_id = p_object_id
4067: and ppr.object_version_id = p_object_version_id
4068: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4080: from pa_progress_rollup ppr

4076: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4077: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)
4078: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4079: into l_actual_cost
4080: from pa_progress_rollup ppr
4081: where ppr.project_id = p_project_id
4082: and ppr.object_id = p_object_id
4083: and ppr.object_version_id = p_object_version_id
4084: and structure_type = 'WORKPLAN'

Line 4122: from pa_progress_rollup ppr

4118: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4119: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
4120: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4121: into l_actual_rawcost
4122: from pa_progress_rollup ppr
4123: where ppr.project_id = p_project_id
4124: and ppr.object_id = p_object_id
4125: and prog_pa_period_name = p_period_name
4126: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4130: from pa_progress_rollup ppr2

4126: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4127: and ppr.structure_version_id IS NULL --bug 3802177
4128: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4129: and ppr.as_of_date = (select max(as_of_date)
4130: from pa_progress_rollup ppr2
4131: where ppr2.project_id = ppr.project_id
4132: and ppr2.object_id = ppr.object_id
4133: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4134: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4147: from pa_progress_rollup ppr

4143: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4144: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
4145: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4146: into l_prev_period_actual_rawcost
4147: from pa_progress_rollup ppr
4148: where ppr.project_id = p_project_id
4149: and ppr.object_id = p_object_id
4150: and ppr.structure_type = 'WORKPLAN'
4151: and ppr.structure_version_id IS NULL

Line 4154: from pa_progress_rollup ppr1

4150: and ppr.structure_type = 'WORKPLAN'
4151: and ppr.structure_version_id IS NULL
4152: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4153: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4154: from pa_progress_rollup ppr1
4155: where ppr1.project_id = ppr.project_id
4156: and ppr1.object_id = ppr.object_id
4157: and ppr1.structure_type = 'WORKPLAN'
4158: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4161: from pa_progress_rollup ppr2

4157: and ppr1.structure_type = 'WORKPLAN'
4158: and ppr1.structure_version_id IS NULL --bug 3802177
4159: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4160: and as_of_date < ( select min(as_of_date)
4161: from pa_progress_rollup ppr2
4162: where ppr2.project_id = ppr1.project_id
4163: and ppr2.object_id = ppr1.object_id
4164: and structure_type = 'WORKPLAN'
4165: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4178: from pa_progress_rollup ppr

4174: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4175: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
4176: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4177: into l_actual_rawcost
4178: from pa_progress_rollup ppr
4179: where ppr.project_id = p_project_id
4180: and ppr.object_id = p_object_id
4181: and prog_gl_period_name = p_period_name
4182: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4186: from pa_progress_rollup ppr2

4182: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4183: and ppr.structure_version_id IS NULL --bug 3802177
4184: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4185: and ppr.as_of_date = (select max(as_of_date)
4186: from pa_progress_rollup ppr2
4187: where ppr2.project_id = ppr.project_id
4188: and ppr2.object_id = ppr.object_id
4189: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4190: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4203: from pa_progress_rollup ppr

4199: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4200: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
4201: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4202: into l_prev_period_actual_rawcost
4203: from pa_progress_rollup ppr
4204: where ppr.project_id = p_project_id
4205: and ppr.object_id = p_object_id
4206: and ppr.structure_type = 'WORKPLAN'
4207: and ppr.structure_version_id IS NULL

Line 4210: from pa_progress_rollup ppr1

4206: and ppr.structure_type = 'WORKPLAN'
4207: and ppr.structure_version_id IS NULL
4208: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4209: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4210: from pa_progress_rollup ppr1
4211: where ppr1.project_id = ppr.project_id
4212: and ppr1.object_id = ppr.object_id
4213: and ppr1.structure_type = 'WORKPLAN'
4214: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4217: from pa_progress_rollup ppr2

4213: and ppr1.structure_type = 'WORKPLAN'
4214: and ppr1.structure_version_id IS NULL --bug 3802177
4215: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4216: and as_of_date < ( select min(as_of_date)
4217: from pa_progress_rollup ppr2
4218: where ppr2.project_id = ppr1.project_id
4219: and ppr2.object_id = ppr1.object_id
4220: and structure_type = 'WORKPLAN'
4221: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4233: from pa_progress_rollup ppr

4229: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4230: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
4231: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4232: into l_actual_rawcost
4233: from pa_progress_rollup ppr
4234: where ppr.project_id = p_project_id
4235: and ppr.object_id = p_object_id
4236: --and ppr.object_version_id = p_object_version_id
4237: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4248: from pa_progress_rollup ppr

4244: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4245: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
4246: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4247: into l_actual_rawcost
4248: from pa_progress_rollup ppr
4249: where ppr.project_id = p_project_id
4250: and ppr.object_id = p_object_id
4251: and ppr.object_version_id = p_object_version_id
4252: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4267: from pa_progress_rollup ppr

4263: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4264: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
4265: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4266: into l_actual_rawcost
4267: from pa_progress_rollup ppr
4268: where ppr.project_id = p_project_id
4269: and ppr.object_id = p_object_id
4270: and prog_pa_period_name = p_period_name
4271: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4275: from pa_progress_rollup ppr2

4271: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4272: and ppr.structure_version_id IS NULL --bug 3802177
4273: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4274: and ppr.as_of_date = (select max(as_of_date)
4275: from pa_progress_rollup ppr2
4276: where ppr2.project_id = ppr.project_id
4277: and ppr2.object_id = ppr.object_id
4278: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4279: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4292: from pa_progress_rollup ppr

4288: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4289: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
4290: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4291: into l_prev_period_actual_rawcost
4292: from pa_progress_rollup ppr
4293: where ppr.project_id = p_project_id
4294: and ppr.object_id = p_object_id
4295: and ppr.structure_type = 'WORKPLAN'
4296: and ppr.structure_version_id IS NULL

Line 4299: from pa_progress_rollup ppr1

4295: and ppr.structure_type = 'WORKPLAN'
4296: and ppr.structure_version_id IS NULL
4297: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4298: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4299: from pa_progress_rollup ppr1
4300: where ppr1.project_id = ppr.project_id
4301: and ppr1.object_id = ppr.object_id
4302: and ppr1.structure_type = 'WORKPLAN'
4303: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4306: from pa_progress_rollup ppr2

4302: and ppr1.structure_type = 'WORKPLAN'
4303: and ppr1.structure_version_id IS NULL --bug 3802177
4304: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4305: and as_of_date < ( select min(as_of_date)
4306: from pa_progress_rollup ppr2
4307: where ppr2.project_id = ppr1.project_id
4308: and ppr2.object_id = ppr1.object_id
4309: and structure_type = 'WORKPLAN'
4310: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4324: from pa_progress_rollup ppr

4320: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4321: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
4322: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4323: into l_actual_rawcost
4324: from pa_progress_rollup ppr
4325: where ppr.project_id = p_project_id
4326: and ppr.object_id = p_object_id
4327: and prog_gl_period_name = p_period_name
4328: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4332: from pa_progress_rollup ppr2

4328: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4329: and ppr.structure_version_id IS NULL --bug 3802177
4330: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4331: and ppr.as_of_date = (select max(as_of_date)
4332: from pa_progress_rollup ppr2
4333: where ppr2.project_id = ppr.project_id
4334: and ppr2.object_id = ppr.object_id
4335: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4336: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4349: from pa_progress_rollup ppr

4345: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4346: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
4347: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4348: into l_prev_period_actual_rawcost
4349: from pa_progress_rollup ppr
4350: where ppr.project_id = p_project_id
4351: and ppr.object_id = p_object_id
4352: and ppr.structure_type = 'WORKPLAN'
4353: and ppr.structure_version_id IS NULL

Line 4356: from pa_progress_rollup ppr1

4352: and ppr.structure_type = 'WORKPLAN'
4353: and ppr.structure_version_id IS NULL
4354: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4355: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4356: from pa_progress_rollup ppr1
4357: where ppr1.project_id = ppr.project_id
4358: and ppr1.object_id = ppr.object_id
4359: and ppr1.structure_type = 'WORKPLAN'
4360: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4363: from pa_progress_rollup ppr2

4359: and ppr1.structure_type = 'WORKPLAN'
4360: and ppr1.structure_version_id IS NULL --bug 3802177
4361: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4362: and as_of_date < ( select min(as_of_date)
4363: from pa_progress_rollup ppr2
4364: where ppr2.project_id = ppr1.project_id
4365: and ppr2.object_id = ppr1.object_id
4366: and structure_type = 'WORKPLAN'
4367: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4379: from pa_progress_rollup ppr

4375: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4376: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
4377: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4378: into l_actual_rawcost
4379: from pa_progress_rollup ppr
4380: where ppr.project_id = p_project_id
4381: and ppr.object_id = p_object_id
4382: and ppr.object_version_id = p_object_version_id
4383: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4394: from pa_progress_rollup ppr

4390: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4391: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
4392: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4393: into l_actual_rawcost
4394: from pa_progress_rollup ppr
4395: where ppr.project_id = p_project_id
4396: and ppr.object_id = p_object_id
4397: and ppr.object_version_id = p_object_version_id
4398: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4413: from pa_progress_rollup ppr

4409: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4410: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
4411: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4412: into l_actual_rawcost
4413: from pa_progress_rollup ppr
4414: where ppr.project_id = p_project_id
4415: and ppr.object_id = p_object_id
4416: and prog_pa_period_name = p_period_name
4417: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4421: from pa_progress_rollup ppr2

4417: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4418: and ppr.structure_version_id IS NULL --bug 3802177
4419: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4420: and ppr.as_of_date = (select max(as_of_date)
4421: from pa_progress_rollup ppr2
4422: where ppr2.project_id = ppr.project_id
4423: and ppr2.object_id = ppr.object_id
4424: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4425: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4438: from pa_progress_rollup ppr

4434: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4435: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
4436: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4437: into l_prev_period_actual_rawcost
4438: from pa_progress_rollup ppr
4439: where ppr.project_id = p_project_id
4440: and ppr.object_id = p_object_id
4441: and ppr.structure_type = 'WORKPLAN'
4442: and ppr.structure_version_id IS NULL

Line 4445: from pa_progress_rollup ppr1

4441: and ppr.structure_type = 'WORKPLAN'
4442: and ppr.structure_version_id IS NULL
4443: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4444: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4445: from pa_progress_rollup ppr1
4446: where ppr1.project_id = ppr.project_id
4447: and ppr1.object_id = ppr.object_id
4448: and ppr1.structure_type = 'WORKPLAN'
4449: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4452: from pa_progress_rollup ppr2

4448: and ppr1.structure_type = 'WORKPLAN'
4449: and ppr1.structure_version_id IS NULL --bug 3802177
4450: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4451: and as_of_date < ( select min(as_of_date)
4452: from pa_progress_rollup ppr2
4453: where ppr2.project_id = ppr1.project_id
4454: and ppr2.object_id = ppr1.object_id
4455: and structure_type = 'WORKPLAN'
4456: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4469: from pa_progress_rollup ppr

4465: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4466: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
4467: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4468: into l_actual_rawcost
4469: from pa_progress_rollup ppr
4470: where ppr.project_id = p_project_id
4471: and ppr.object_id = p_object_id
4472: and prog_gl_period_name = p_period_name
4473: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4477: from pa_progress_rollup ppr2

4473: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4474: and ppr.structure_version_id IS NULL --bug 3802177
4475: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4476: and ppr.as_of_date = (select max(as_of_date)
4477: from pa_progress_rollup ppr2
4478: where ppr2.project_id = ppr.project_id
4479: and ppr2.object_id = ppr.object_id
4480: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4481: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4494: from pa_progress_rollup ppr

4490: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4491: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
4492: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4493: into l_prev_period_actual_rawcost
4494: from pa_progress_rollup ppr
4495: where ppr.project_id = p_project_id
4496: and ppr.object_id = p_object_id
4497: and ppr.structure_type = 'WORKPLAN'
4498: and ppr.structure_version_id IS NULL

Line 4501: from pa_progress_rollup ppr1

4497: and ppr.structure_type = 'WORKPLAN'
4498: and ppr.structure_version_id IS NULL
4499: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4500: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4501: from pa_progress_rollup ppr1
4502: where ppr1.project_id = ppr.project_id
4503: and ppr1.object_id = ppr.object_id
4504: and ppr1.structure_type = 'WORKPLAN'
4505: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4508: from pa_progress_rollup ppr2

4504: and ppr1.structure_type = 'WORKPLAN'
4505: and ppr1.structure_version_id IS NULL --bug 3802177
4506: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4507: and as_of_date < ( select min(as_of_date)
4508: from pa_progress_rollup ppr2
4509: where ppr2.project_id = ppr1.project_id
4510: and ppr2.object_id = ppr1.object_id
4511: and structure_type = 'WORKPLAN'
4512: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4524: from pa_progress_rollup ppr

4520: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4521: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
4522: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4523: into l_actual_rawcost
4524: from pa_progress_rollup ppr
4525: where ppr.project_id = p_project_id
4526: and ppr.object_id = p_object_id
4527: and ppr.object_version_id = p_object_version_id
4528: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4539: from pa_progress_rollup ppr

4535: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4536: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
4537: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4538: into l_actual_rawcost
4539: from pa_progress_rollup ppr
4540: where ppr.project_id = p_project_id
4541: and ppr.object_id = p_object_id
4542: and ppr.object_version_id = p_object_version_id
4543: and structure_type = 'WORKPLAN'

Line 4575: from pa_progress_rollup ppr

4571: --maansari6/15 3694031
4572: begin
4573: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4574: into l_actual_effort
4575: from pa_progress_rollup ppr
4576: where ppr.project_id = p_project_id
4577: and ppr.object_id = p_object_id
4578: and prog_pa_period_name = p_period_name
4579: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4583: from pa_progress_rollup ppr2

4579: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4580: and ppr.structure_version_id IS NULL --bug 3802177
4581: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4582: and ppr.as_of_date = (select max(as_of_date)
4583: from pa_progress_rollup ppr2
4584: where ppr2.project_id = ppr.project_id
4585: and ppr2.object_id = ppr.object_id
4586: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4587: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4598: from pa_progress_rollup ppr

4594:
4595: begin
4596: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4597: into l_prev_period_actual_effort
4598: from pa_progress_rollup ppr
4599: where ppr.project_id = p_project_id
4600: and ppr.object_id = p_object_id
4601: and ppr.structure_type = 'WORKPLAN'
4602: and ppr.structure_version_id IS NULL

Line 4605: from pa_progress_rollup ppr1

4601: and ppr.structure_type = 'WORKPLAN'
4602: and ppr.structure_version_id IS NULL
4603: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4604: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4605: from pa_progress_rollup ppr1
4606: where ppr1.project_id = ppr.project_id
4607: and ppr1.object_id = ppr.object_id
4608: and ppr1.structure_type = 'WORKPLAN'
4609: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4612: from pa_progress_rollup ppr2

4608: and ppr1.structure_type = 'WORKPLAN'
4609: and ppr1.structure_version_id IS NULL --bug 3802177
4610: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4611: and as_of_date < ( select min(as_of_date)
4612: from pa_progress_rollup ppr2
4613: where ppr2.project_id = ppr1.project_id
4614: and ppr2.object_id = ppr1.object_id
4615: and structure_type = 'WORKPLAN'
4616: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4629: from pa_progress_rollup ppr

4625: --maansari6/15 3694031
4626: begin
4627: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4628: into l_actual_effort
4629: from pa_progress_rollup ppr
4630: where ppr.project_id = p_project_id
4631: and ppr.object_id = p_object_id
4632: and prog_gl_period_name = p_period_name
4633: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4637: from pa_progress_rollup ppr2

4633: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4634: and ppr.structure_version_id IS NULL --bug 3802177
4635: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4636: and ppr.as_of_date = (select max(as_of_date)
4637: from pa_progress_rollup ppr2
4638: where ppr2.project_id = ppr.project_id
4639: and ppr2.object_id = ppr.object_id
4640: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4641: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4652: from pa_progress_rollup ppr

4648:
4649: begin
4650: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4651: into l_prev_period_actual_effort
4652: from pa_progress_rollup ppr
4653: where ppr.project_id = p_project_id
4654: and ppr.object_id = p_object_id
4655: and ppr.structure_type = 'WORKPLAN'
4656: and ppr.structure_version_id IS NULL

Line 4659: from pa_progress_rollup ppr1

4655: and ppr.structure_type = 'WORKPLAN'
4656: and ppr.structure_version_id IS NULL
4657: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4658: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4659: from pa_progress_rollup ppr1
4660: where ppr1.project_id = ppr.project_id
4661: and ppr1.object_id = ppr.object_id
4662: and ppr1.structure_type = 'WORKPLAN'
4663: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4666: from pa_progress_rollup ppr2

4662: and ppr1.structure_type = 'WORKPLAN'
4663: and ppr1.structure_version_id IS NULL --bug 3802177
4664: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4665: and as_of_date < ( select min(as_of_date)
4666: from pa_progress_rollup ppr2
4667: where ppr2.project_id = ppr1.project_id
4668: and ppr2.object_id = ppr1.object_id
4669: and structure_type = 'WORKPLAN'
4670: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4682: from pa_progress_rollup ppr

4678:
4679: elsif (pgn_flag = 'N') then
4680: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4681: into l_actual_effort
4682: from pa_progress_rollup ppr
4683: where ppr.project_id = p_project_id
4684: and ppr.object_id = p_object_id
4685: and ppr.object_version_id = p_object_version_id
4686: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4696: from pa_progress_rollup ppr

4692: ELSIF p_structure_version_id IS NOT NULL
4693: THEN
4694: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4695: into l_actual_effort
4696: from pa_progress_rollup ppr
4697: where ppr.project_id = p_project_id
4698: and ppr.object_id = p_object_id
4699: and ppr.object_version_id = p_object_version_id
4700: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4726: from pa_progress_rollup ppr

4722: cursor c_prev_prog_rec is
4723: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
4724: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
4725: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0)) act_cost_to_date
4726: from pa_progress_rollup ppr
4727: where ppr.project_id = p_project_id
4728: and ppr.object_id = p_object_id
4729: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4730: and ppr.structure_version_id is null -- Bug 3764224

Line 4739: from pa_progress_rollup ppr

4735: cursor c_this_prog_rec is
4736: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
4737: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
4738: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0)) act_cost_to_date
4739: from pa_progress_rollup ppr
4740: where ppr.project_id = p_project_id
4741: and ppr.object_id = p_object_id
4742: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4743: and ppr.structure_version_id is null -- Bug 3764224

Line 4780: from pa_progress_rollup ppr

4776:
4777: /*
4778: cursor c1 is
4779: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4780: from pa_progress_rollup ppr
4781: where ppr.project_id = p_project_id
4782: and ppr.object_id = p_object_id
4783: -- and ppr.object_version_id = p_object_version_id
4784: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4787: from pa_progress_rollup ppr2

4783: -- and ppr.object_version_id = p_object_version_id
4784: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4785: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.
4786: and ppr.as_of_date = (select max(ppr2.as_of_date)
4787: from pa_progress_rollup ppr2
4788: where ppr2.project_id = p_project_id
4789: and ppr2.object_id = p_object_id
4790: -- and ppr2.object_version_id = p_object_version_id
4791: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4800: from pa_progress_rollup ppr

4796:
4797: /* BEGIN: Commenting code for Bug # 3808127.
4798: cursor c_prev_prog_rec is
4799: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4800: from pa_progress_rollup ppr
4801: where ppr.project_id = p_project_id
4802: and ppr.object_id = p_object_id
4803: -- and ppr.object_version_id = p_object_version_id
4804: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4808: from pa_progress_rollup ppr2

4804: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4805: and ppr.structure_version_id is null -- Bug 3764224
4806: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
4807: and ppr.as_of_date = (select max(ppr2.as_of_date)
4808: from pa_progress_rollup ppr2
4809: where ppr2.project_id = p_project_id
4810: and ppr2.object_id = p_object_id
4811: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4812: and ppr2.structure_version_id is null -- Bug 3764224

Line 4818: from pa_progress_rollup ppr

4814: and ppr2.as_of_date < p_as_of_date);
4815:
4816: cursor c_this_prog_rec is
4817: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4818: from pa_progress_rollup ppr
4819: where ppr.project_id = p_project_id
4820: and ppr.object_id = p_object_id
4821: -- and ppr.object_version_id = p_object_version_id
4822: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4826: from pa_progress_rollup ppr2

4822: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4823: and ppr.structure_version_id is null -- Bug 3764224
4824: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
4825: and ppr.as_of_date = (select max(ppr2.as_of_date)
4826: from pa_progress_rollup ppr2
4827: where ppr2.project_id = p_project_id
4828: and ppr2.object_id = p_object_id
4829: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4830: and ppr2.structure_version_id is null -- Bug 3764224

Line 4842: from pa_progress_rollup ppr

4838: cursor c_prev_prog_rec is
4839: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
4840: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
4841: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4842: from pa_progress_rollup ppr
4843: where ppr.project_id = p_project_id
4844: and ppr.object_id = p_object_id
4845: -- and ppr.object_version_id = p_object_version_id
4846: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4856: from pa_progress_rollup ppr

4852: cursor c_this_prog_rec is
4853: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
4854: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
4855: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4856: from pa_progress_rollup ppr
4857: -- Bug 3879461 : No need to have percent complete table join now we can directly check current_flag as W
4858: -- ,pa_percent_completes ppc
4859: where ppr.project_id = p_project_id
4860: and ppr.object_id = p_object_id

Line 4888: from pa_progress_rollup ppr,pa_percent_completes ppc

4884: fetch c1 into l_c1rec;
4885: if c1%found then
4886: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.subprj_oth_act_cost_to_date_tc,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
4887: into l_act_cost_pub
4888: from pa_progress_rollup ppr,pa_percent_completes ppc
4889: where ppr.project_id = ppc.project_id
4890: and ppr.object_id = ppc.object_id
4891: and ppr.object_version_id = ppc.object_version_id
4892: and ppr.as_of_date = ppc.date_computed (+)

Line 4992: FROM pa_progress_rollup ppr

4988: (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0))--+nvl(ppr.oth_quantity_to_date,0))Oth quantity is not required as it can be in diffrent UOM
4989: +nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0) act_effort,
4990: (nvl(ppr.estimated_remaining_effort,0)+nvl(ppr.eqpmt_etc_effort,0))--+nvl(ppr.oth_etc_quantity,0))Oth quantity is not required as it can be in diffrent UOM
4991: +nvl(ppr.subprj_ppl_etc_effort,0)+nvl(ppr.subprj_eqpmt_etc_effort,0) etc_effort
4992: FROM pa_progress_rollup ppr
4993: WHERE ppr.project_id = p_project_id
4994: AND ppr.object_id = p_object_id
4995: AND ppr.object_type = p_object_type
4996: AND ppr.structure_version_id = p_structure_version_id

Line 5029: FROM pa_progress_rollup ppr

5025: (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0))--+nvl(ppr.oth_quantity_to_date,0))Oth quantity is not required as it can be in diffrent UOM
5026: +nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0) act_effort,
5027: (nvl(ppr.estimated_remaining_effort,0)+nvl(ppr.eqpmt_etc_effort,0))--+nvl(ppr.oth_etc_quantity,0))Oth quantity is not required as it can be in diffrent UOM
5028: +nvl(ppr.subprj_ppl_etc_effort,0)+nvl(ppr.subprj_eqpmt_etc_effort,0) etc_effort
5029: FROM pa_progress_rollup ppr
5030: WHERE ppr.project_id = p_project_id
5031: AND ppr.object_id = p_object_id
5032: AND ppr.object_type = p_object_type
5033: AND ppr.structure_version_id is null

Line 5039: FROM pa_progress_rollup ppr2

5035: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
5036: AND ppr.current_flag <> 'W' -- Bug 3879461
5037: AND trunc(as_of_date) = (
5038: SELECT trunc(max(as_of_date))
5039: FROM pa_progress_rollup ppr2
5040: WHERE ppr2.project_id = p_project_id
5041: AND ppr2.object_id = p_object_id
5042: AND ppr2.object_type = p_object_type
5043: AND ppr2.structure_version_id is null

Line 5152: from pa_progress_rollup ppr

5148:
5149: /*
5150: cursor c1 is
5151: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0)) act_cost_to_date
5152: from pa_progress_rollup ppr
5153: where ppr.project_id = p_project_id
5154: and ppr.object_id = p_object_id
5155: -- and ppr.object_version_id = p_object_version_id
5156: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5159: from pa_progress_rollup ppr2

5155: -- and ppr.object_version_id = p_object_version_id
5156: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
5157: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) --Modified for IB4 Progress CR.
5158: and ppr.as_of_date = (select max(ppr2.as_of_date)
5159: from pa_progress_rollup ppr2
5160: where ppr2.project_id = p_project_id
5161: and ppr2.object_id = p_object_id
5162: -- and ppr2.object_version_id = p_object_version_id
5163: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5171: from pa_progress_rollup ppr

5167: */
5168:
5169: cursor c_prev_prog_rec is
5170: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0)) act_cost_to_date
5171: from pa_progress_rollup ppr
5172: where ppr.project_id = p_project_id
5173: and ppr.object_id = p_object_id
5174: -- and ppr.object_version_id = p_object_version_id
5175: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5179: from pa_progress_rollup ppr2

5175: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5176: and ppr.structure_version_id is null -- Bug 3764224
5177: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
5178: and ppr.as_of_date = (select max(ppr2.as_of_date)
5179: from pa_progress_rollup ppr2
5180: where ppr2.project_id = p_project_id
5181: and ppr2.object_id = p_object_id
5182: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5183: and ppr2.structure_version_id is null -- Bug 3764224

Line 5189: from pa_progress_rollup ppr

5185: and ppr2.as_of_date < p_as_of_date);
5186:
5187: cursor c_this_prog_rec is
5188: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0)) act_cost_to_date
5189: from pa_progress_rollup ppr
5190: where ppr.project_id = p_project_id
5191: and ppr.object_id = p_object_id
5192: -- and ppr.object_version_id = p_object_version_id
5193: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5197: from pa_progress_rollup ppr2

5193: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5194: and ppr.structure_version_id is null -- Bug 3764224
5195: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
5196: and ppr.as_of_date = (select max(ppr2.as_of_date)
5197: from pa_progress_rollup ppr2
5198: where ppr2.project_id = p_project_id
5199: and ppr2.object_id = p_object_id
5200: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5201: and ppr2.structure_version_id is null -- Bug 3764224

Line 5216: from pa_progress_rollup ppr,pa_percent_completes ppc

5212: fetch c1 into l_c1rec;
5213: if c1%found then
5214: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.subprj_oth_act_cost_to_date_fc,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
5215: into l_act_cost_pub
5216: from pa_progress_rollup ppr,pa_percent_completes ppc
5217: where ppr.project_id = ppc.project_id
5218: and ppr.object_id = ppc.object_id
5219: and ppr.object_version_id = ppc.object_version_id
5220: and ppr.as_of_date = ppc.date_computed (+)

Line 5278: from pa_progress_rollup ppr

5274:
5275: /*
5276: cursor c1 is
5277: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5278: from pa_progress_rollup ppr
5279: where ppr.project_id = p_project_id
5280: and ppr.object_id = p_object_id
5281: -- and ppr.object_version_id = p_object_version_id
5282: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5284: from pa_progress_rollup ppr2

5280: and ppr.object_id = p_object_id
5281: -- and ppr.object_version_id = p_object_version_id
5282: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5283: and ppr.as_of_date = (select max(ppr2.as_of_date)
5284: from pa_progress_rollup ppr2
5285: where ppr2.project_id = p_project_id
5286: and ppr2.object_id = p_object_id
5287: -- and ppr2.object_version_id = p_object_version_id
5288: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5294: from pa_progress_rollup ppr

5290: */
5291:
5292: cursor c_prev_prog_rec is
5293: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5294: from pa_progress_rollup ppr
5295: where ppr.project_id = p_project_id
5296: and ppr.object_id = p_object_id
5297: -- and ppr.object_version_id = p_object_version_id
5298: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5305: from pa_progress_rollup ppr2

5301: and current_flag = 'Y'
5302: ;
5303: /* commented by maansari7/25
5304: and ppr.as_of_date = (select max(ppr2.as_of_date)
5305: from pa_progress_rollup ppr2
5306: where ppr2.project_id = p_project_id
5307: and ppr2.object_id = p_object_id
5308: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5309: and ppr2.structure_version_id is null -- Bug 3764224

Line 5316: from pa_progress_rollup ppr

5312: */
5313:
5314: cursor c_this_prog_rec is
5315: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5316: from pa_progress_rollup ppr
5317: -- Bug 3879461 : Now percent complete join is not required. current_flag = W can be used
5318: -- ,pa_percent_completes ppc
5319: where ppr.project_id = p_project_id
5320: and ppr.object_id = p_object_id

Line 5337: from pa_progress_rollup ppr2

5333: and ppr.current_flag= 'W'
5334: ;
5335: /* commented by maansari7/25
5336: and ppr.as_of_date = (select max(ppr2.as_of_date)
5337: from pa_progress_rollup ppr2
5338: where ppr2.project_id = p_project_id
5339: and ppr2.object_id = p_object_id
5340: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5341: and ppr2.structure_version_id is null -- Bug 3764224

Line 5353: -- from pa_progress_rollup ppr,pa_percent_completes ppc

5349: -- Bug 3764224 : RLM Changes : This code is commented, the earlier cusrsor code c1 was fine expept instead of greater than it should have been less than sign
5350: -- cursor cur_effort_this_period
5351: -- is
5352: -- select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
5353: -- from pa_progress_rollup ppr,pa_percent_completes ppc
5354: -- where ppr.project_id = ppc.project_id
5355: -- and ppr.object_id = ppc.object_id
5356: -- and ppr.as_of_date = ppc.date_computed
5357: -- and ppr.project_id = p_project_id

Line 5379: from pa_progress_rollup ppr,pa_percent_completes ppc

5375: fetch c1 into l_c1rec;
5376: if c1%found then
5377: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
5378: into l_act_effort_pub
5379: from pa_progress_rollup ppr,pa_percent_completes ppc
5380: where ppr.project_id = ppc.project_id
5381: and ppr.object_id = ppc.object_id
5382: and ppr.object_version_id = ppc.object_version_id
5383: and ppr.as_of_date = ppc.date_computed (+)

Line 5459: from pa_progress_rollup ppr

5455: and ppevs.element_version_id = p_structure_version_id
5456: and ppevs.date_prog_applied_on_wver < (select max(l_update_date)
5457: from (
5458: select max(last_update_date) l_update_date
5459: from pa_progress_rollup ppr
5460: where ppr.project_id = p_project_id
5461: and object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5462: and structure_type = 'WORKPLAN'
5463: and current_flag = 'Y'

Line 5479: from pa_progress_rollup ppr

5475: where ppevs.project_id = p_project_id
5476: and ppevs.element_version_id = p_structure_version_id
5477: and ppevs.date_prog_applied_on_wver is null
5478: and exists (select '1'
5479: from pa_progress_rollup ppr
5480: where ppr.project_id = p_project_id
5481: and object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5482: and structure_type = 'WORKPLAN'
5483: and current_flag = 'Y'

Line 5526: FROM pa_progress_rollup ppr

5522: If nvl(l_program_flag,'N') = 'Y' then
5523: SELECT
5524: MAX(ppr.last_update_date)
5525: INTO l_last_update_date
5526: FROM pa_progress_rollup ppr
5527: WHERE ppr.project_id = p_project_id
5528: AND ppr.object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5529: AND ppr.structure_type = 'WORKPLAN'
5530: AND ppr.current_flag = 'Y'

Line 5536: FROM pa_progress_rollup ppr, pa_proj_elem_ver_structure ppevs

5532: else
5533: SELECT
5534: MAX(ppr.last_update_date)
5535: INTO l_last_update_date
5536: FROM pa_progress_rollup ppr, pa_proj_elem_ver_structure ppevs
5537: WHERE ppr.project_id = p_project_id
5538: AND ppr.object_id = ppevs.PROJ_ELEMENT_ID
5539: AND ppr.object_type ='PA_STRUCTURES'
5540: AND ppr.structure_type = 'WORKPLAN'

Line 5579: FROM pa_progress_rollup ppr

5575: SELECT 'N'
5576: INTO l_return_value
5577: FROM DUAL
5578: WHERE EXISTS ( SELECT '1'
5579: FROM pa_progress_rollup ppr
5580: WHERE ppr.project_id = p_project_id
5581: AND object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5582: AND structure_type = 'WORKPLAN'
5583: AND current_flag = 'Y'

Line 5839: from pa_progress_rollup ppr

5835: l_return_status VARCHAR2(1) := 'N';
5836: -- FPM Dev CR 7 : Note that p_proj_element_id is not needed, but keeping it to avoid impacts to other code
5837: CURSOR myCursor is
5838: select 'Y'
5839: from pa_progress_rollup ppr
5840: where ppr.project_id = p_project_id
5841: and ppr.object_id = p_object_id
5842: and ppr.object_type = p_object_type
5843: and ppr.structure_type = p_structure_type

Line 5851: from pa_progress_rollup ppr

5847: ;
5848:
5849: CURSOR myCursor_pub is
5850: select 'Y'
5851: from pa_progress_rollup ppr
5852: where ppr.project_id = p_project_id
5853: and ppr.object_id = p_object_id
5854: and ppr.object_type = p_object_type
5855: and ppr.structure_type = p_structure_type

Line 5968: From PA_Progress_Rollup

5964: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
5965: 'FINANCIAL_PLANNING',
5966: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
5967: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
5968: From PA_Progress_Rollup
5969: Where Project_ID = P_Project_ID
5970: AND Object_ID = P_Proj_Element_ID
5971: AND Object_Type = p_object_type
5972: AND current_flag <> 'W' --bug 3879461

Line 5973: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

5969: Where Project_ID = P_Project_ID
5970: AND Object_ID = P_Proj_Element_ID
5971: AND Object_Type = p_object_type
5972: AND current_flag <> 'W' --bug 3879461
5973: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
5974: where Project_ID = P_Project_ID
5975: AND Object_ID = P_Proj_Element_ID
5976: AND Object_Type = p_object_type
5977: AND structure_version_id IS NULL

Line 5994: From PA_Progress_Rollup

5990: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
5991: 'FINANCIAL_PLANNING',
5992: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
5993: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
5994: From PA_Progress_Rollup
5995: Where Project_ID = P_Project_ID
5996: AND Object_Type = p_object_type
5997: AND current_flag <> 'W' --bug 3879461
5998: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

Line 5998: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

5994: From PA_Progress_Rollup
5995: Where Project_ID = P_Project_ID
5996: AND Object_Type = p_object_type
5997: AND current_flag <> 'W' --bug 3879461
5998: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
5999: where Project_ID = P_Project_ID
6000: AND Object_Type = p_object_type
6001: AND structure_version_id IS NULL
6002: AND current_flag <> 'W' --bug 3879461

Line 6020: From PA_Progress_Rollup

6016: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6017: 'FINANCIAL_PLANNING',
6018: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6019: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6020: From PA_Progress_Rollup
6021: Where Project_ID = P_Project_ID
6022: AND Object_ID = P_Proj_Element_ID
6023: AND Object_Type = p_object_type
6024: AND current_flag = 'W' --bug 3879461

Line 6025: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

6021: Where Project_ID = P_Project_ID
6022: AND Object_ID = P_Proj_Element_ID
6023: AND Object_Type = p_object_type
6024: AND current_flag = 'W' --bug 3879461
6025: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
6026: where Project_ID = P_Project_ID
6027: AND Object_ID = P_Proj_Element_ID
6028: AND Object_Type = p_object_type
6029: AND structure_version_id IS NULL

Line 6046: From PA_Progress_Rollup

6042: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6043: 'FINANCIAL_PLANNING',
6044: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6045: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6046: From PA_Progress_Rollup
6047: Where Project_ID = P_Project_ID
6048: AND Object_Type = p_object_type
6049: AND current_flag = 'W' --bug 3879461
6050: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

Line 6050: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

6046: From PA_Progress_Rollup
6047: Where Project_ID = P_Project_ID
6048: AND Object_Type = p_object_type
6049: AND current_flag = 'W' --bug 3879461
6050: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
6051: where Project_ID = P_Project_ID
6052: AND Object_Type = p_object_type
6053: AND structure_version_id IS NULL
6054: AND current_flag = 'W' --bug 3879461

Line 6075: From PA_Progress_Rollup

6071: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6072: 'FINANCIAL_PLANNING',
6073: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6074: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6075: From PA_Progress_Rollup
6076: Where Project_ID = P_Project_ID
6077: AND Object_ID = P_Proj_Element_ID
6078: AND Object_Type = p_object_type
6079: --AND As_Of_Date = p_As_Of_Date

Line 6093: From PA_Progress_Rollup

6089: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6090: 'FINANCIAL_PLANNING',
6091: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6092: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6093: From PA_Progress_Rollup
6094: Where Project_ID = P_Project_ID
6095: AND Object_Type = p_object_type
6096: --AND As_Of_Date = p_As_Of_Date
6097: AND structure_version_id = p_structure_version_id

Line 6292: From PA_Progress_Rollup

6288:
6289: --Select (l_Planned_Amount*P_Overide_Percent_Complete)/100
6290: /*
6291: INTO x_BCWP -- Earned Value
6292: From PA_Progress_Rollup
6293: Where Project_ID = P_Project_ID
6294: AND Proj_Element_ID = P_Proj_Element_ID
6295: AND object_id = P_Proj_Element_ID
6296: --AND Object_Type = 'PA_ASSIGNMENTS'

Line 6465: FROM PA_Progress_Rollup

6461: IS
6462: Cursor CUR_Est_Sch_Dates
6463: IS
6464: Select MIN(Estimated_Start_Date), MAX(Estimated_Finish_Date), MIN(Actual_Start_Date), MAX(Actual_Finish_Date)
6465: FROM PA_Progress_Rollup
6466: Where Project_ID = P_Project_ID
6467: AND Proj_Element_ID = P_Proj_Element_ID
6468: AND Object_Type = 'PA_ASSIGNMENTS'
6469: AND As_Of_Date = p_As_Of_Date

Line 6862: from pa_progress_rollup

6858: l_rollup_date date;
6859: CURSOR cur_rollupdate
6860: IS
6861: select max(as_of_date)
6862: from pa_progress_rollup
6863: where project_id = p_project_id
6864: and object_id = p_object_id
6865: and object_type = p_object_type
6866: and structure_type = p_structure_type -- FPM Dev CR 4

Line 7099: from pa_progress_rollup ppr1

7095: eqpmt_act_effort_to_date, ppl_act_cost_to_date_tc, eqpmt_act_cost_to_date_tc, oth_act_cost_to_date_tc,
7096: txn_currency_code, ppl_act_rawcost_to_date_pc, eqpmt_act_rawcost_to_date_pc, oth_act_rawcost_to_date_pc,
7097: ppl_act_rawcost_to_date_fc, eqpmt_act_rawcost_to_date_fc, oth_act_rawcost_to_date_fc,
7098: ppl_act_rawcost_to_date_tc, eqpmt_act_rawcost_to_date_tc, oth_act_rawcost_to_date_tc, oth_quantity_to_date
7099: from pa_progress_rollup ppr1
7100: where ppr1.project_id = p_project_id
7101: and ppr1.object_id = p_object_id
7102: and ppr1.structure_version_id is null
7103: AND ppr1.current_flag <> 'W' -- Bug 3879461

Line 7105: from pa_progress_rollup ppr2

7101: and ppr1.object_id = p_object_id
7102: and ppr1.structure_version_id is null
7103: AND ppr1.current_flag <> 'W' -- Bug 3879461
7104: and ppr1.as_of_date = ( SELECT max(ppr2.as_of_date)
7105: from pa_progress_rollup ppr2
7106: WHERE ppr2.as_of_date <= p_as_of_date
7107: AND ppr2.object_id = p_object_id
7108: AND ppr2.project_id = p_project_id
7109: and ppr2.structure_type = 'WORKPLAN'

Line 7123: from pa_progress_rollup ppr1

7119: eqpmt_act_effort_to_date, ppl_act_cost_to_date_tc, eqpmt_act_cost_to_date_tc, oth_act_cost_to_date_tc,
7120: txn_currency_code, ppl_act_rawcost_to_date_pc, eqpmt_act_rawcost_to_date_pc, oth_act_rawcost_to_date_pc,
7121: ppl_act_rawcost_to_date_fc, eqpmt_act_rawcost_to_date_fc, oth_act_rawcost_to_date_fc,
7122: ppl_act_rawcost_to_date_tc, eqpmt_act_rawcost_to_date_tc, oth_act_rawcost_to_date_tc, oth_quantity_to_date
7123: from pa_progress_rollup ppr1
7124: where ppr1.project_id = p_project_id
7125: and ppr1.object_id = p_object_id
7126: and ppr1.proj_element_id = p_proj_element_id
7127: and ppr1.structure_version_id is null

Line 7130: from pa_progress_rollup ppr2

7126: and ppr1.proj_element_id = p_proj_element_id
7127: and ppr1.structure_version_id is null
7128: AND ppr1.current_flag <> 'W' -- Bug 3879461
7129: and ppr1.as_of_date = ( SELECT max(ppr2.as_of_date)
7130: from pa_progress_rollup ppr2
7131: WHERE ppr2.as_of_date <= p_as_of_date
7132: AND ppr2.object_id = p_object_id
7133: AND ppr2.proj_element_id = p_proj_element_id
7134: AND ppr2.project_id = p_project_id

Line 7166: from pa_progress_rollup ppr1

7162: cursor c1_proj_level IS
7163: select cumulative_work_quantity, ppl_act_cost_to_date_pc, eqpmt_act_cost_to_date_pc, oth_act_cost_to_date_pc,
7164: ppl_act_cost_to_date_fc, eqpmt_act_cost_to_date_fc, oth_act_cost_to_date_fc, ppl_act_effort_to_date,
7165: eqpmt_act_effort_to_date
7166: from pa_progress_rollup ppr1
7167: where ppr1.project_id = p_project_id
7168: and ppr1.object_type = 'PA_STRUCTURES'
7169: and ppr1.structure_version_id is null
7170: AND ppr1.current_flag <> 'W' -- Bug 3879461

Line 7172: from pa_progress_rollup ppr2

7168: and ppr1.object_type = 'PA_STRUCTURES'
7169: and ppr1.structure_version_id is null
7170: AND ppr1.current_flag <> 'W' -- Bug 3879461
7171: and ppr1.as_of_date = ( SELECT max(ppr2.as_of_date)
7172: from pa_progress_rollup ppr2
7173: WHERE ppr2.as_of_date <= p_as_of_date
7174: AND ppr2.object_type = 'PA_STRUCTURES'
7175: AND ppr2.project_id = p_project_id
7176: and ppr2.structure_type = 'WORKPLAN'

Line 7432: FROM pa_progress_rollup

7428:
7429: CURSOR cur_task_etc_effort
7430: IS
7431: SELECT NVL( ESTIMATED_REMAINING_EFFORT, 0 ) + NVL( EQPMT_ETC_EFFORT, 0 )
7432: FROM pa_progress_rollup
7433: WHERE project_id = p_project_id
7434: AND object_id = p_object_id
7435: and proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7436: --Commented by rtarway for BUG 3835474

Line 7438: from pa_progress_rollup

7434: AND object_id = p_object_id
7435: and proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7436: --Commented by rtarway for BUG 3835474
7437: /*AND as_of_date = ( SELECT max(as_of_date)
7438: from pa_progress_rollup
7439: WHERE as_of_date < p_as_of_date
7440: AND project_id = p_project_id
7441: AND object_id = p_object_id
7442: AND object_type = p_object_type

Line 7448: from pa_progress_rollup ppr2

7444: and proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR.
7445: )*/
7446: --Added by rtarway for BUG 3835474
7447: AND as_of_date = ( SELECT max(as_of_date)
7448: from pa_progress_rollup ppr2
7449: WHERE ppr2.as_of_date <= p_as_of_date
7450: AND ppr2.project_id = p_project_id
7451: AND ppr2.object_id = p_object_id
7452: AND ppr2.object_type = p_object_type

Line 7495: FROM pa_progress_rollup ppr

7491:
7492: CURSOR cur_task_etc_cost
7493: IS
7494: SELECT (nvl(ppr.oth_etc_cost_tc,0)+nvl(ppr.ppl_etc_cost_tc,0)+nvl(ppr.eqpmt_etc_cost_tc,0))
7495: FROM pa_progress_rollup ppr
7496: WHERE ppr.project_id = p_project_id
7497: AND ppr.object_id = p_object_id
7498: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7499: AND ppr.as_of_date = ( SELECT max(as_of_date)

Line 7500: from pa_progress_rollup ppr2

7496: WHERE ppr.project_id = p_project_id
7497: AND ppr.object_id = p_object_id
7498: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7499: AND ppr.as_of_date = ( SELECT max(as_of_date)
7500: from pa_progress_rollup ppr2
7501: WHERE ppr2.as_of_date < p_as_of_date
7502: AND ppr2.project_id = p_project_id
7503: AND ppr2.object_id = p_object_id
7504: AND ppr2.object_type = p_object_type

Line 7559: FROM pa_progress_rollup ppr

7555: ,(nvl(ppr.oth_etc_cost_tc,0)+nvl(ppr.ppl_etc_cost_tc,0)+nvl(ppr.eqpmt_etc_cost_tc,0)) etc_txn_bur_cost_last_subm
7556: ,(nvl(ppr.oth_etc_cost_pc,0)+nvl(ppr.ppl_etc_cost_pc,0)+nvl(ppr.eqpmt_etc_cost_pc,0)) etc_prj_bur_cost_last_subm
7557: ,(nvl(ppr.oth_etc_cost_fc,0)+nvl(ppr.ppl_etc_cost_fc,0)+nvl(ppr.eqpmt_etc_cost_fc,0)) etc_pfc_bur_cost_last_subm
7558: , (NVL( ESTIMATED_REMAINING_EFFORT, 0 ) + NVL( EQPMT_ETC_EFFORT, 0 )) etc_effort_last_subm
7559: FROM pa_progress_rollup ppr
7560: WHERE ppr.project_id = p_project_id
7561: AND ppr.object_id = p_object_id
7562: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id)
7563: --Commented by rtarway for BUG 3835474

Line 7565: -- from pa_progress_rollup ppr2

7561: AND ppr.object_id = p_object_id
7562: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id)
7563: --Commented by rtarway for BUG 3835474
7564: --AND ppr.as_of_date = ( SELECT max(as_of_date)
7565: -- from pa_progress_rollup ppr2
7566: -- WHERE ppr2.as_of_date < p_as_of_date
7567: -- AND ppr2.project_id = p_project_id
7568: -- AND ppr2.object_id = p_object_id
7569: -- AND ppr2.object_type = p_object_type

Line 7575: from pa_progress_rollup ppr2

7571: --and ppr2.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.
7572: -- )
7573: --Added by rtarway for BUG 3835474
7574: AND ppr.as_of_date = ( SELECT max(as_of_date)
7575: from pa_progress_rollup ppr2
7576: WHERE ppr2.as_of_date <= p_as_of_date
7577: AND ppr2.project_id = p_project_id
7578: AND ppr2.object_id = p_object_id
7579: AND ppr2.object_type = p_object_type

Line 7663: FROM pa_progress_rollup ppr

7659: ,ppr.oth_etc_cost_fc ) etc_pfc_bur_cost_last_subm
7660: ,decode(p_resource_class_code, 'PEOPLE', ESTIMATED_REMAINING_EFFORT
7661: ,'EQUIPMENT', EQPMT_ETC_EFFORT
7662: , ppr.OTH_ETC_QUANTITY) etc_effort_last_subm
7663: FROM pa_progress_rollup ppr
7664: WHERE ppr.project_id = p_project_id
7665: AND ppr.object_id = p_object_id
7666: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7667: AND ppr.as_of_date = ( SELECT max(as_of_date)

Line 7668: from pa_progress_rollup ppr2

7664: WHERE ppr.project_id = p_project_id
7665: AND ppr.object_id = p_object_id
7666: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7667: AND ppr.as_of_date = ( SELECT max(as_of_date)
7668: from pa_progress_rollup ppr2
7669: WHERE ppr2.as_of_date <= p_as_of_date--Added eqaulity condition, 4091457, rtarway
7670: AND ppr2.project_id = p_project_id
7671: AND ppr2.object_id = p_object_id
7672: AND ppr2.object_type = p_object_type

Line 7787: from pa_progress_rollup ppr

7783: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7784: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
7785: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7786: act_rawcost_to_date
7787: from pa_progress_rollup ppr
7788: where ppr.project_id = p_project_id
7789: and ppr.object_id = p_object_id
7790: -- and ppr.object_version_id = p_object_version_id
7791: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7794: from pa_progress_rollup ppr2

7790: -- and ppr.object_version_id = p_object_version_id
7791: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
7792: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id)-- Modified for IB4 Progress CR.
7793: and ppr.as_of_date = (select max(ppr2.as_of_date)
7794: from pa_progress_rollup ppr2
7795: where ppr2.project_id = p_project_id
7796: and ppr2.object_id = p_object_id
7797: -- and ppr2.object_version_id = p_object_version_id
7798: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7809: from pa_progress_rollup ppr

7805: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7806: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
7807: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7808: act_rawcost_to_date
7809: from pa_progress_rollup ppr
7810: where ppr.project_id = p_project_id
7811: and ppr.object_id = p_object_id
7812: -- and ppr.object_version_id = p_object_version_id
7813: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7817: from pa_progress_rollup ppr2

7813: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7814: and ppr.structure_version_id is null -- Bug 3764224
7815: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
7816: and ppr.as_of_date = (select max(ppr2.as_of_date)
7817: from pa_progress_rollup ppr2
7818: where ppr2.project_id = p_project_id
7819: and ppr2.object_id = p_object_id
7820: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7821: and ppr2.structure_version_id is null -- Bug 3764224

Line 7830: from pa_progress_rollup ppr

7826: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7827: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
7828: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7829: act_rawcost_to_date
7830: from pa_progress_rollup ppr
7831: where ppr.project_id = p_project_id
7832: and ppr.object_id = p_object_id
7833: -- and ppr.object_version_id = p_object_version_id
7834: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7838: from pa_progress_rollup ppr2

7834: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7835: and ppr.structure_version_id is null -- Bug 3764224
7836: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
7837: and ppr.as_of_date = (select max(ppr2.as_of_date)
7838: from pa_progress_rollup ppr2
7839: where ppr2.project_id = p_project_id
7840: and ppr2.object_id = p_object_id
7841: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7842: and ppr2.structure_version_id is null -- Bug 3764224

Line 7859: from pa_progress_rollup ppr,pa_percent_completes ppc

7855: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7856: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_pc,0)
7857: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7858: into l_act_rawcost_pub
7859: from pa_progress_rollup ppr,pa_percent_completes ppc
7860: where ppr.project_id = ppc.project_id
7861: and ppr.object_id = ppc.object_id
7862: and ppr.object_version_id = ppc.object_version_id
7863: and ppr.as_of_date = ppc.date_computed (+)

Line 7924: from pa_progress_rollup ppr

7920: cursor c1 is
7921: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7922: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
7923: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7924: from pa_progress_rollup ppr
7925: where ppr.project_id = p_project_id
7926: and ppr.object_id = p_object_id
7927: -- and ppr.object_version_id = p_object_version_id
7928: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7930: from pa_progress_rollup ppr2

7926: and ppr.object_id = p_object_id
7927: -- and ppr.object_version_id = p_object_version_id
7928: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
7929: and ppr.as_of_date = (select max(ppr2.as_of_date)
7930: from pa_progress_rollup ppr2
7931: where ppr2.project_id = p_project_id
7932: and ppr2.object_id = p_object_id
7933: -- and ppr2.object_version_id = p_object_version_id
7934: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7945: from pa_progress_rollup ppr,pa_percent_completes ppc

7941: is
7942: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7943: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
7944: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7945: from pa_progress_rollup ppr,pa_percent_completes ppc
7946: where ppr.project_id = ppc.project_id
7947: and ppr.object_id = ppc.object_id
7948: and ppr.as_of_date = ppc.date_computed
7949: and ppr.project_id = p_project_id

Line 7966: from pa_progress_rollup ppr

7962: cursor c_prev_prog_rec is
7963: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7964: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
7965: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7966: from pa_progress_rollup ppr
7967: where ppr.project_id = p_project_id
7968: and ppr.object_id = p_object_id
7969: -- and ppr.object_version_id = p_object_version_id
7970: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7981: from pa_progress_rollup ppr

7977: cursor c_prev_prog_rec is
7978: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7979: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
7980: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7981: from pa_progress_rollup ppr
7982: where ppr.project_id = p_project_id
7983: and ppr.object_id = p_object_id
7984: -- and ppr.object_version_id = p_object_version_id
7985: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7989: from pa_progress_rollup ppr2

7985: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7986: and ppr.structure_version_id is null -- Bug 3764224
7987: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
7988: and ppr.as_of_date = (select max(ppr2.as_of_date)
7989: from pa_progress_rollup ppr2
7990: where ppr2.project_id = p_project_id
7991: and ppr2.object_id = p_object_id
7992: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7993: and ppr2.structure_version_id is null -- Bug 3764224

Line 8003: from pa_progress_rollup ppr

7999: cursor c_this_prog_rec is
8000: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8001: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
8002: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8003: from pa_progress_rollup ppr
8004: where ppr.project_id = p_project_id
8005: and ppr.object_id = p_object_id
8006: -- and ppr.object_version_id = p_object_version_id
8007: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8011: from pa_progress_rollup ppr2

8007: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8008: and ppr.structure_version_id is null -- Bug 3764224
8009: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8010: and ppr.as_of_date = (select max(ppr2.as_of_date)
8011: from pa_progress_rollup ppr2
8012: where ppr2.project_id = p_project_id
8013: and ppr2.object_id = p_object_id
8014: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8015: and ppr2.structure_version_id is null -- Bug 3764224

Line 8024: from pa_progress_rollup ppr

8020: cursor c_this_prog_rec is
8021: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8022: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
8023: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8024: from pa_progress_rollup ppr
8025: -- Bug 3879461 : percemnt compete join is not required. current_flag = W is sufficient
8026: -- ,pa_percent_completes ppc
8027: where ppr.project_id = p_project_id
8028: and ppr.object_id = p_object_id

Line 8059: from pa_progress_rollup ppr,pa_percent_completes ppc

8055: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8056: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
8057: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
8058: into l_act_rawcost_pub
8059: from pa_progress_rollup ppr,pa_percent_completes ppc
8060: where ppr.project_id = ppc.project_id
8061: and ppr.object_id = ppc.object_id
8062: and ppr.object_version_id = ppc.object_version_id
8063: and ppr.as_of_date = ppc.date_computed (+)

Line 8147: from pa_progress_rollup ppr

8143: cursor c1 is
8144: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8145: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
8146: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0)) act_rawcost_to_date
8147: from pa_progress_rollup ppr
8148: where ppr.project_id = p_project_id
8149: and ppr.object_id = p_object_id
8150: -- and ppr.object_version_id = p_object_version_id
8151: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.

Line 8154: from pa_progress_rollup ppr2

8150: -- and ppr.object_version_id = p_object_version_id
8151: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.
8152: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
8153: and ppr.as_of_date = (select max(ppr2.as_of_date)
8154: from pa_progress_rollup ppr2
8155: where ppr2.project_id = p_project_id
8156: and ppr2.object_id = p_object_id
8157: -- and ppr2.object_version_id = p_object_version_id
8158: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8168: from pa_progress_rollup ppr

8164: cursor c_prev_prog_rec is
8165: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8166: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
8167: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0)) act_rawcost_to_date
8168: from pa_progress_rollup ppr
8169: where ppr.project_id = p_project_id
8170: and ppr.object_id = p_object_id
8171: -- and ppr.object_version_id = p_object_version_id
8172: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8176: from pa_progress_rollup ppr2

8172: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8173: and ppr.structure_version_id is null -- Bug 3764224
8174: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8175: and ppr.as_of_date = (select max(ppr2.as_of_date)
8176: from pa_progress_rollup ppr2
8177: where ppr2.project_id = p_project_id
8178: and ppr2.object_id = p_object_id
8179: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8180: and ppr2.structure_version_id is null -- Bug 3764224

Line 8188: from pa_progress_rollup ppr

8184: cursor c_this_prog_rec is
8185: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8186: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
8187: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0)) act_rawcost_to_date
8188: from pa_progress_rollup ppr
8189: where ppr.project_id = p_project_id
8190: and ppr.object_id = p_object_id
8191: -- and ppr.object_version_id = p_object_version_id
8192: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8196: from pa_progress_rollup ppr2

8192: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8193: and ppr.structure_version_id is null -- Bug 3764224
8194: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8195: and ppr.as_of_date = (select max(ppr2.as_of_date)
8196: from pa_progress_rollup ppr2
8197: where ppr2.project_id = p_project_id
8198: and ppr2.object_id = p_object_id
8199: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8200: and ppr2.structure_version_id is null -- Bug 3764224

Line 8219: from pa_progress_rollup ppr,pa_percent_completes ppc

8215: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8216: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.spj_oth_act_rawcost_to_date_fc,0)
8217: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
8218: into l_act_rawcost_pub
8219: from pa_progress_rollup ppr,pa_percent_completes ppc
8220: where ppr.project_id = ppc.project_id
8221: and ppr.object_id = ppc.object_id
8222: and ppr.object_version_id = ppc.object_version_id
8223: and ppr.as_of_date = ppc.date_computed (+)

Line 9929: from pa_progress_rollup ppr

9925: l_last_submitted_perc_comp NUMBER ;
9926: Cursor c_get_last_submitted_perc_comp
9927: is
9928: select ppr.completed_percentage
9929: from pa_progress_rollup ppr
9930: where ppr.project_id = p_project_id
9931: and ppr.object_id = p_object_id
9932: and ppr.structure_type = 'WORKPLAN'
9933: and ppr.structure_version_id is null

Line 9939: from pa_progress_rollup ppr2

9935: and ppr.current_flag <> 'W' -- Bug 3879461
9936: and ppr.as_of_date =
9937: (
9938: select max(ppr2.as_of_date)
9939: from pa_progress_rollup ppr2
9940: where ppr2.project_id = p_project_id
9941: and ppr2.object_id = p_object_id
9942: and ppr2.structure_type = 'WORKPLAN'
9943: and ppr2.structure_version_id is null

Line 10075: pa_progress_rollup pr

10071: pa_proj_elements pe,
10072: pa_resource_assignments ra,
10073: pa_resource_list_members rlm,
10074: pa_budget_lines bl,
10075: pa_progress_rollup pr
10076: WHERE
10077: pev.parent_structure_version_id = p_struct_ver_id AND
10078: pe.proj_element_id = pev.proj_element_id AND
10079: ra.wbs_element_version_id = pev.element_version_id AND

Line 10216: pa_progress_rollup pr

10212: FROM
10213: pa_res_asgmts_temp rat,
10214: pa_resource_assignments ra,
10215: pa_proj_element_versions pev,
10216: pa_progress_rollup pr
10217: WHERE
10218: ra.resource_assignment_id = rat.resource_assignment_id AND
10219: pev.element_version_id = ra.wbs_element_version_id AND
10220: pr.project_id = ra.project_id AND

Line 10918: from pa_progress_rollup

10914: */
10915: --- Bug 4652132 always return latest as_of_date for the project/program.
10916: select as_of_date
10917: into l_prog_act_summ_date
10918: from pa_progress_rollup
10919: where project_id = p_project_id
10920: and object_type = 'PA_STRUCTURES'
10921: and structure_type = 'WORKPLAN'
10922: and structure_version_id is null

Line 11030: FROM pa_progress_rollup ppr

11026: CURSOR cur_ppr_assgn(c_object_id NUMBER, c_task_id NUMBER, c_object_type VARCHAR2
11027: , c_project_id NUMBER, c_structure_type VARCHAR2)
11028: IS
11029: SELECT 'Y'
11030: FROM pa_progress_rollup ppr
11031: WHERE ppr.object_id = c_object_id
11032: AND ppr.proj_element_id = c_task_id
11033: AND ppr.object_type = c_object_type
11034: AND ppr.project_id = c_project_id

Line 11067: FROM pa_progress_rollup ppr

11063: CURSOR cur_ppr_task(c_task_id NUMBER, c_object_type VARCHAR2
11064: , c_project_id NUMBER, c_structure_type VARCHAR2)
11065: IS
11066: SELECT 'Y'
11067: FROM pa_progress_rollup ppr
11068: WHERE ppr.proj_element_id = c_task_id
11069: AND ppr.object_type = c_object_type
11070: AND ppr.project_id = c_project_id
11071: AND ppr.structure_type = p_structure_type

Line 11128: DELETE FROM pa_progress_rollup ppr

11124: -- the rollup records for the assignment.
11125:
11126: if ((l_return_value = 'N') and (p_delete_progress_flag = 'Y')) then -- fix for Bug # 4140984.
11127:
11128: DELETE FROM pa_progress_rollup ppr
11129: WHERE ppr.object_id = p_object_id
11130: AND ppr.proj_element_id = p_task_id
11131: AND ppr.object_type = p_object_type
11132: AND ppr.project_id = p_project_id

Line 11170: DELETE FROM pa_progress_rollup ppr

11166: -- delete all the rollup records for all the assignments for the given task.
11167:
11168: if ((l_return_value = 'N') and (p_delete_progress_flag = 'Y')) then -- Fix for Bug # 4140984.
11169:
11170: DELETE FROM pa_progress_rollup ppr
11171: WHERE ppr.proj_element_id = p_task_id
11172: AND ppr.object_type = 'PA_ASSIGNMENTS'
11173: AND ppr.project_id = p_project_id
11174: AND ppr.structure_type = p_structure_type;

Line 11652: , pa_progress_rollup ppr

11648: nvl(asgn.planned_bur_cost_proj_cur,0)
11649: ))) bac_value_in_task_deriv
11650: FROM
11651: pa_task_asgmts_v asgn
11652: , pa_progress_rollup ppr
11653: WHERE asgn.task_version_id = c_task_ver_id
11654: AND asgn.project_id = p_project_id ---4871809
11655: AND asgn.task_id = p_proj_element_id
11656: AND asgn.ta_display_flag = 'Y'

Line 11725: FROM pa_progress_rollup

11721: , c_structure_version_id NUMBER
11722: , c_as_of_date DATE)
11723: IS
11724: SELECT max(as_of_date)
11725: FROM pa_progress_rollup
11726: WHERE project_id = c_project_id
11727: AND object_id = c_object_id
11728: AND object_type = c_object_type
11729: AND structure_type = c_structure_type

Line 11744: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.

11740: , c_published_structure VARCHAR2
11741: , c_structure_version_id NUMBER)
11742: IS
11743: SELECT max(as_of_date)
11744: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.
11745: WHERE ppr.project_id = c_project_id
11746: AND ppr.object_id = c_object_id
11747: AND ppr.object_type = c_object_type
11748: AND ppr.structure_type = c_structure_type

Line 11768: FROM pa_progress_rollup ppr

11764: )
11765: IS
11766: SELECT nvl(ppr.completed_percentage,decode(nvl(c_program_flag,'Y'),'Y', ppr.eff_rollup_percent_comp, ppr.base_percent_complete))
11767: -- 4392189 : Program Reporting Changes - Phase 2 : Added Decode above
11768: FROM pa_progress_rollup ppr
11769: WHERE ppr.project_id = c_project_id
11770: and ppr.object_id = c_object_id
11771: and ppr.object_type = c_object_type
11772: and ppr.structure_type = c_structure_type

Line 11825: -- then use the max as_of_date in the pa_progress_rollup_table less than or equal to

11821: FETCH cur_check_published_version INTO l_published_structure;
11822: CLOSE cur_check_published_version;
11823:
11824: -- 2.1). If the input structure_type is 'FINANCIAL' and input as_of_date is not null
11825: -- then use the max as_of_date in the pa_progress_rollup_table less than or equal to
11826: -- the input as_of_date.
11827:
11828: if ((p_structure_type = 'FINANCIAL') and (p_as_of_date is not null)) then
11829:

Line 11836: -- 2.2). Else use the latest as_of_date in the pa_progress_rollup table for the

11832: , p_structure_version_id, p_as_of_date);
11833: fetch cur_max_as_of_date_leq into l_as_of_date;
11834: close cur_max_as_of_date_leq;
11835:
11836: -- 2.2). Else use the latest as_of_date in the pa_progress_rollup table for the
11837: -- given task or structure.
11838:
11839: else
11840:

Line 11851: -- from the pa_progress_rollup table for the above determined as_of_date.

11847: end if;
11848:
11849: -- 3.1). If the p_include_sub_tasks_flag = 'Y' or if the input proj_element_id
11850: -- is a structure_id then return the rolled-up percent complete for the task
11851: -- from the pa_progress_rollup table for the above determined as_of_date.
11852:
11853: if ((p_include_sub_tasks_flag = 'Y') or (p_object_type = 'PA_STRUCTURES')) then
11854:
11855: open cur_percent_comp(p_project_id, p_proj_element_id, p_object_type

Line 11947: from pa_progress_rollup ppr

11943: +nvl(ppr.eqpmt_act_effort_to_date,0)
11944: +nvl(ppr.subprj_ppl_act_effort,0)
11945: +nvl(ppr.subprj_eqpmt_act_effort,0)
11946: +nvl(ppr.oth_quantity_to_date,0)) act_effort_prev_asofdate
11947: from pa_progress_rollup ppr
11948: where ppr.project_id = p_project_id
11949: and ppr.object_id = p_object_id
11950: and ppr.structure_type = 'WORKPLAN'
11951: and ppr.proj_element_id = p_proj_element_id

Line 11954: from pa_progress_rollup ppr2

11950: and ppr.structure_type = 'WORKPLAN'
11951: and ppr.proj_element_id = p_proj_element_id
11952: and ppr.structure_version_id is null
11953: and ppr.as_of_date = (select max(ppr2.as_of_date)
11954: from pa_progress_rollup ppr2
11955: where ppr2.project_id = p_project_id
11956: and ppr2.object_id = p_object_id
11957: and ppr2.structure_type = 'WORKPLAN'
11958: and ppr2.proj_element_id = p_proj_element_id

Line 11975: from pa_progress_rollup ppr

11971: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)
11972: +nvl(ppr.subprj_oth_act_cost_to_date_tc,0)
11973: +nvl(ppr.subprj_ppl_act_cost_tc,0)
11974: +nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_bur_cost_tc_prev_asofdate
11975: from pa_progress_rollup ppr
11976: where ppr.project_id = p_project_id
11977: and ppr.object_id = p_object_id
11978: and ppr.structure_type = 'WORKPLAN'
11979: and ppr.proj_element_id = p_proj_element_id

Line 11982: from pa_progress_rollup ppr2

11978: and ppr.structure_type = 'WORKPLAN'
11979: and ppr.proj_element_id = p_proj_element_id
11980: and ppr.structure_version_id is null
11981: and ppr.as_of_date = (select max(ppr2.as_of_date)
11982: from pa_progress_rollup ppr2
11983: where ppr2.project_id = p_project_id
11984: and ppr2.object_id = p_object_id
11985: and ppr2.structure_type = 'WORKPLAN'
11986: and ppr2.proj_element_id = p_proj_element_id

Line 12001: from pa_progress_rollup ppr

11997: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)
11998: +nvl(ppr.subprj_oth_act_cost_to_date_pc,0)
11999: +nvl(ppr.subprj_ppl_act_cost_pc,0)
12000: +nvl(ppr.subprj_eqpmt_act_cost_pc,0)) act_bur_cost_pc_prev_asofdate
12001: from pa_progress_rollup ppr
12002: where ppr.project_id = p_project_id
12003: and ppr.object_id = p_object_id
12004: and ppr.structure_type = 'WORKPLAN'
12005: and ppr.proj_element_id = p_proj_element_id

Line 12008: from pa_progress_rollup ppr2

12004: and ppr.structure_type = 'WORKPLAN'
12005: and ppr.proj_element_id = p_proj_element_id
12006: and ppr.structure_version_id is null
12007: and ppr.as_of_date = (select max(ppr2.as_of_date)
12008: from pa_progress_rollup ppr2
12009: where ppr2.project_id = p_project_id
12010: and ppr2.object_id = p_object_id
12011: and ppr2.structure_type = 'WORKPLAN'
12012: and ppr2.proj_element_id = p_proj_element_id

Line 12028: from pa_progress_rollup ppr

12024: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)
12025: +nvl(ppr.spj_oth_act_rawcost_to_date_tc,0)
12026: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)
12027: +nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_raw_cost_tc_prev_asofdate
12028: from pa_progress_rollup ppr
12029: where ppr.project_id = p_project_id
12030: and ppr.object_id = p_object_id
12031: and ppr.structure_type = 'WORKPLAN'
12032: and ppr.proj_element_id = p_proj_element_id

Line 12035: from pa_progress_rollup ppr2

12031: and ppr.structure_type = 'WORKPLAN'
12032: and ppr.proj_element_id = p_proj_element_id
12033: and ppr.structure_version_id is null
12034: and ppr.as_of_date = (select max(ppr2.as_of_date)
12035: from pa_progress_rollup ppr2
12036: where ppr2.project_id = p_project_id
12037: and ppr2.object_id = p_object_id
12038: and ppr2.structure_type = 'WORKPLAN'
12039: and ppr2.proj_element_id = p_proj_element_id

Line 12324: from pa_progress_rollup ppr

12320: select nvl(ppl_act_effort_to_date,0) asgn_act_eff
12321: ,nvl(ppl_act_cost_to_date_pc,0) asgn_act_cost
12322: ,nvl(estimated_remaining_effort,0) asgn_etc_eff
12323: ,nvl(ppl_etc_cost_pc,0) agn_etc_cost
12324: from pa_progress_rollup ppr
12325: where ppr.project_id = p_project_id
12326: and ppr.proj_element_id = p_proj_element_id
12327: and ppr.structure_type = 'WORKPLAN'
12328: and ppr.structure_version_id is null

Line 12433: FROM pa_progress_rollup

12429: p_as_of_date IN date,
12430: p_chk_task IN varchar2 default 'Y') return number is
12431: cursor get_work_prog_rollupid is
12432: select progress_rollup_id
12433: FROM pa_progress_rollup
12434: WHERE project_id = p_project_id
12435: AND object_id = p_object_id
12436: AND decode(p_chk_task,'Y',proj_element_id,p_task_id) = p_task_id
12437: AND object_type = p_object_type

Line 12445: from pa_progress_rollup ppr

12441: AND current_flag = 'W';
12442:
12443: cursor get_pub_prog_rollupid is
12444: select progress_rollup_id
12445: from pa_progress_rollup ppr
12446: WHERE ppr.project_id = p_project_id
12447: AND ppr.object_id = p_object_id
12448: AND decode(p_chk_task,'Y',ppr.proj_element_id,p_task_id) = p_task_id
12449: AND ppr.object_type = p_object_Type

Line 12453: from pa_progress_rollup

12449: AND ppr.object_type = p_object_Type
12450: AND ppr.structure_type = 'WORKPLAN'
12451: AND ppr.structure_version_id is null
12452: AND ppr.as_of_date = (select max(as_of_date)
12453: from pa_progress_rollup
12454: where project_id = p_project_id
12455: AND object_id = p_object_id
12456: AND decode(p_chk_task,'Y',proj_element_id,p_task_id) = p_task_id
12457: AND object_type = p_object_Type

Line 12491: FROM pa_progress_rollup

12487: p_task_id IN number,
12488: p_chk_task IN varchar2 default 'N') return varchar2 is
12489: cursor get_w_pub_currflag is
12490: select current_flag
12491: FROM pa_progress_rollup
12492: WHERE project_id = p_project_id
12493: AND object_id = p_object_id
12494: AND object_type = p_object_type
12495: AND decode(p_chk_task,'Y',proj_element_id,nvl(p_task_id,-99)) = nvl(p_task_id,-99)

Line 12519: pa_progress_rollup ppr

12515: cursor C_TA_PROG_CURSOR is
12516: select 'Y'
12517: from
12518: pa_resource_assignments pra,
12519: pa_progress_rollup ppr
12520: where pra.ta_display_flag = 'N'
12521: and pra.wbs_element_version_id = p_element_ver_id
12522: and pra.project_id = p_project_id
12523: and ppr.project_id = p_project_id

Line 12552: -- Bug 7259306 - Outer join added to the inner inline view for all 6 cursors on pa_progress_rollup table.

12548: PROCEDURE get_plan_value(p_project_id number, p_structure_version_id number, p_element_id number, p_as_of_date date)
12549:
12550: IS
12551:
12552: -- Bug 7259306 - Outer join added to the inner inline view for all 6 cursors on pa_progress_rollup table.
12553:
12554: -- Working as of date
12555:
12556: --This cursor retrieves the accumulated amounts for the periods before each task before as of date period

Line 12578: from pa_progress_rollup ppr,

12574: PJI_TIME_CAL_PERIOD_V ptcpv,
12575: (
12576: select ppv.proj_element_id proj_element_id,
12577: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12578: from pa_progress_rollup ppr,
12579: pa_proj_element_versions ppv
12580: where ppv.parent_structure_version_id=p_structure_version_id
12581: and ppv.project_id=p_project_id
12582: and ppv.proj_element_id=p_proj_element_id

Line 12631: from pa_progress_rollup ppr,

12627: PJI_TIME_CAL_PERIOD_V ptcpv,
12628: (
12629: select ppv.proj_element_id proj_element_id,
12630: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12631: from pa_progress_rollup ppr,
12632: pa_proj_element_versions ppv
12633: where ppv.parent_structure_version_id=p_structure_version_id
12634: and ppv.project_id=p_project_id
12635: and ppv.proj_element_id=p_proj_element_id

Line 12685: from pa_progress_rollup ppr,

12681: PJI_TIME_CAL_PERIOD_V ptcpv,
12682: (
12683: select ppv.proj_element_id proj_element_id,
12684: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12685: from pa_progress_rollup ppr,
12686: pa_proj_element_versions ppv
12687: where ppv.parent_structure_version_id=p_structure_version_id
12688: and ppv.project_id=p_project_id
12689: and ppv.proj_element_id=p_proj_element_id

Line 12739: from pa_progress_rollup ppr,

12735: PJI_TIME_CAL_PERIOD_V ptcpv,
12736: (
12737: select ppv.proj_element_id proj_element_id,
12738: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12739: from pa_progress_rollup ppr,
12740: pa_proj_element_versions ppv
12741: where ppv.parent_structure_version_id=p_structure_version_id
12742: and ppv.project_id=p_project_id
12743: and ppv.proj_element_id=p_proj_element_id

Line 12796: from pa_progress_rollup ppr,

12792: (
12793: select ppv.proj_element_id proj_element_id,
12794: max(ppv.parent_structure_version_id) parent_structure_id,
12795: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12796: from pa_progress_rollup ppr,
12797: pa_proj_element_versions ppv
12798: where ppv.parent_structure_version_id<=p_structure_version_id
12799: and ppv.project_id=p_project_id
12800: and ppv.proj_element_id=p_proj_element_id

Line 12851: from pa_progress_rollup ppr,

12847: (
12848: select ppv.proj_element_id proj_element_id,
12849: max(ppv.parent_structure_version_id) parent_structure_id,
12850: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12851: from pa_progress_rollup ppr,
12852: pa_proj_element_versions ppv
12853: where ppv.parent_structure_version_id<=p_structure_version_id
12854: and ppv.project_id=p_project_id
12855: and ppv.proj_element_id=p_proj_element_id

Line 13194: p_project_id pa_progress_rollup.project_id%TYPE,

13190: -- Bug 7259306
13191: -- Returns the date displayed in the Progress Report tab
13192: -- Cursor is based on the VO - ProgressAsOfDatesVO which is used to populate the 'as of date' poplist
13193: FUNCTION get_def_as_of_date_prog_report(
13194: p_project_id pa_progress_rollup.project_id%TYPE,
13195: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,
13196: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'
13197: ) RETURN DATE IS
13198: l_return_date DATE;

Line 13195: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,

13191: -- Returns the date displayed in the Progress Report tab
13192: -- Cursor is based on the VO - ProgressAsOfDatesVO which is used to populate the 'as of date' poplist
13193: FUNCTION get_def_as_of_date_prog_report(
13194: p_project_id pa_progress_rollup.project_id%TYPE,
13195: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,
13196: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'
13197: ) RETURN DATE IS
13198: l_return_date DATE;
13199:

Line 13196: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'

13192: -- Cursor is based on the VO - ProgressAsOfDatesVO which is used to populate the 'as of date' poplist
13193: FUNCTION get_def_as_of_date_prog_report(
13194: p_project_id pa_progress_rollup.project_id%TYPE,
13195: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,
13196: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'
13197: ) RETURN DATE IS
13198: l_return_date DATE;
13199:
13200: CURSOR cur_get_def_as_of_date