[Home] [Help]
604: ,p_partname => 'P'||g_worker_id
605: ,p_percent => 10);
606:
607: GATHER_TEMP_STATS(p_ownname => l_pji_schema
608: ,p_tabname => 'PJI_FM_EXTR_PLNVER4'
609: ,p_partname => 'P'||g_worker_id
610: ,p_percent => 10);
611:
612: GATHER_TEMP_STATS(p_ownname => l_pji_schema
1061: FROM
1062: PJI_FP_AGGR_PJP1 fact1
1063: , pji_time_CAL_PERIOD period
1064: , pji_time_CAL_QTR qtr
1065: , pji_fm_extr_plnver4 ver
1066: WHERE
1067: fact1.calendar_type in ( p_calendar_type
1068: , DECODE (p_calendar_type ,'C','G','X')
1069: , DECODE (p_calendar_type ,'C',
1347: , fact.plan_type_code plan_type_code
1348: FROM pji_fp_aggr_pjp1 fact
1349: , pji_time_cal_period_v non_pa_cal
1350: , pji_time_ent_period_v pa_cal
1351: , pji_fm_extr_plnver4 ver
1352: , (SELECT currency_code,
1353: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1354: null, 0.01,
1355: 0, 1,
1640: / (fact.end_date - fact.start_date+1) factor
1641: , fact.plan_type_code plan_type_code
1642: FROM pji_fp_aggr_pjp1 fact
1643: , pji_time_ent_period_v entCal
1644: , pji_fm_extr_plnver4 ver
1645: , (SELECT currency_code,
1646: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1647: null, 0.01,
1648: 0, 1,
1945: FROM
1946: pji_time_cal_period_v pri
1947: , pji_org_extr_info orginfo
1948: , pji_time_cal_period_v sec
1949: , pji_fm_extr_plnver4 ver
1950: , pa_projects_all ppa
1951: WHERE 1=1
1952: AND ppa.org_id=orginfo.org_id
1953: AND ver.worker_id = g_worker_id
2256: , fact.plan_type_code plan_type_code
2257: FROM pji_fp_aggr_pjp1 fact
2258: , pji_org_extr_info orginfo
2259: , pji_time_cal_period_v pa_cal
2260: , pji_fm_extr_plnver4 ver
2261: ,(SELECT currency_code,
2262: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
2263: null, 0.01,
2264: 0, 1,
2785: , TO_DATE(NULL)
2786: ) end_date
2787: FROM pa_budget_lines bl
2788: , pji_time_cal_period_v prd
2789: , PJI_FM_EXTR_PLNVER4 ver
2790: , pa_projects_all ppa
2791: ,PJI_ORG_EXTR_INFO inf
2792: WHERE 1=1
2793: AND bl.budget_version_id = ver.plan_version_id
2825: , ra.planning_end_date
2826: , TO_DATE(NULL)
2827: ) end_date
2828: FROM pa_resource_assignments ra
2829: , PJI_FM_EXTR_PLNVER4 ver
2830: , pa_projects_all ppa
2831: WHERE 1=1
2832: AND ra.budget_version_id = ver.plan_version_id
2833: AND ver.wp_flag = 'N'
2839:
2840: PJI_UTILS.g_max_roll_days := NULL;
2841:
2842: /* Added for bug 13897252 starts */
2843: UPDATE PJI_FM_EXTR_PLNVER4 ver
2844: SET rate_dangling_flag = 'Y'
2845: WHERE EXISTS
2846: ( SELECT NULL
2847: FROM PA_BUDGET_LINES bl,
2970: , l_created_by
2971: , l_last_update_login
2972: , bv.plan_type_code
2973: FROM
2974: PJI_FM_EXTR_PLNVER4 bv,
2975: PA_RBS_PRJ_ASSIGNMENTS rpa,
2976: PJI_PJP_RBS_HEADER head
2977: WHERE bv.project_id = rpa.project_id
2978: AND bv.worker_id = g_worker_id
3774: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3775: , ver.plan_type_code plan_type_code /*4471527 */
3776: , ver.WP_FLAG
3777: FROM
3778: PJI_FM_EXTR_PLNVER4 ver
3779: , pa_resource_asSIGNments ra
3780: , PA_BUDGET_LINES bl
3781: , pa_projects_all ppa
3782: , PJI_ORG_EXTR_INFO oei
4065: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
4066: , ver.plan_type_code plan_type_code /*4471527 */
4067: , ver.WP_FLAG
4068: FROM
4069: PJI_FM_EXTR_PLNVER4 ver
4070: , pa_resource_asSIGNments ra
4071: , PA_BUDGET_LINES bl
4072: , pa_projects_all ppa
4073: , PJI_FM_AGGR_DLY_RATES rates
4353: ,g_default_prg_level PRG_LEVEL
4354: , fact.plan_type_code plan_type_code
4355: FROM
4356: pji_fp_xbs_accum_f fact,
4357: pji_fm_extr_plnver4 ver,
4358: pa_proj_fp_options fp
4359: WHERE fact.plan_version_id=ver.plan_version_id
4360: AND fact.project_id = fp.project_id
4361: AND fact.plan_type_id = fp.fin_plan_type_id