[Home] [Help]
738: END IF;
739: END IF;*/
740:
741: /*
742: INSERT INTO PJI_FM_EXTR_PLNVER4
743: (
744: WORKER_ID ,
745: PROJECT_ID ,
746: PLAN_VERSION_ID ,
968: FROM
969: PJI_FP_AGGR_PJP1 fact1
970: , pji_time_CAL_PERIOD period
971: , pji_time_CAL_QTR qtr
972: , pji_fm_extr_plnver4 ver
973: WHERE
974: -- cal type changes for bug 6381284
975: --fact1.calendar_type = p_calendar_type
976: fact1.calendar_type in ( p_calendar_type
1010: , fact1.PLAN_TYPE_CODE ) /*4471527 */
1011: WHERE period_type_id = 2048;
1012:
1013:
1014: -- DELETE FROM PJI_FM_EXTR_PLNVER4
1015: -- WHERE plan_version_id = -1
1016: -- AND worker_id = g_worker_id;
1017:
1018: EXCEPTION
2938: , fact.rate_dangling_flag rate_dangling_flag
2939: FROM pji_fp_aggr_pjp1 fact
2940: , pji_time_cal_period non_pa_cal
2941: , pji_time_ent_period pa_cal
2942: , pji_fm_extr_plnver4 ver
2943: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
2944: AND fact.worker_id = g_worker_id
2945: AND non_pa_cal.cal_period_id = fact.time_id
2946: AND fact.line_type like 'OF%'
3217: , fact.plan_type_code plan_type_code /* 4471527 */
3218: FROM pji_fp_aggr_pjp1 fact
3219: , pji_time_cal_period_v non_pa_cal
3220: , pji_time_ent_period_v pa_cal
3221: , pji_fm_extr_plnver4 ver
3222: , (SELECT currency_code,
3223: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3224: null, 0.01,
3225: 0, 1,
3526: / (fact.end_date - fact.start_date+1) factor
3527: , fact.plan_type_code plan_type_code /* 4471527 */
3528: FROM pji_fp_aggr_pjp1 fact
3529: , pji_time_ent_period_v entCal
3530: , pji_fm_extr_plnver4 ver
3531: , (SELECT currency_code,
3532: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3533: null, 0.01,
3534: 0, 1,
3752: FROM pji_fp_aggr_pjp1 fact
3753: , pji_time_cal_period non_pa_cal
3754: -- , pji_org_extr_info orginfo
3755: , pji_time_ent_period pa_cal
3756: , pji_fm_extr_plnver4 ver
3757: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3758: AND fact.worker_id = g_worker_id
3759: AND ver.worker_id = g_worker_id
3760: AND non_pa_cal.cal_period_id = fact.time_id
3946: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
3947: FROM pji_fp_aggr_pjp1 fact
3948: , pji_time_cal_period_v non_pa_cal
3949: , pji_time_ent_period_v pa_cal
3950: , pji_fm_extr_plnver4 ver
3951: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3952: AND fact.worker_id = g_worker_id
3953: AND ver.worker_id = g_worker_id
3954: AND non_pa_cal.cal_period_id = fact.time_id
4168: , g_default_prg_level prg_level
4169: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4170: FROM pji_fp_aggr_pjp1 fact
4171: , pji_time_ent_period_v pa_cal
4172: , pji_fm_extr_plnver4 ver
4173: WHERE fact.CALENDAR_TYPE = 'A'
4174: AND fact.worker_id = g_worker_id
4175: AND ver.worker_id = g_worker_id
4176: AND fact.line_type = 'NTP'
4468: FROM
4469: pji_time_cal_period_v pri
4470: , pji_org_extr_info orginfo
4471: , pji_time_cal_period_v sec
4472: , pji_fm_extr_plnver4 ver
4473: , pa_projects_all ppa
4474: WHERE 1=1
4475: AND ppa.org_id=orginfo.org_id
4476: AND ver.worker_id = g_worker_id
4794: , fact.plan_type_code plan_type_code /* 4471527 */
4795: FROM pji_fp_aggr_pjp1 fact
4796: , pji_org_extr_info orginfo
4797: , pji_time_cal_period_v pa_cal
4798: , pji_fm_extr_plnver4 ver
4799: ,(SELECT currency_code,
4800: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4801: null, 0.01,
4802: 0, 1,
5021: FROM pji_fp_aggr_pjp1 fact
5022: , pji_time_cal_period_v non_pa_cal
5023: , pji_org_extr_info orginfo
5024: , pji_time_cal_period_v pa_cal
5025: , pji_fm_extr_plnver4 ver
5026: WHERE fact.CALENDAR_TYPE <> p_calendar_type
5027: AND fact.worker_id = g_worker_id
5028: AND ver.worker_id = g_worker_id
5029: AND fact.CALENDAR_TYPE IN ('P', 'G')
5246: , fact.plan_type_code PLAN_TYPE_CODE /* 4471527 */
5247: FROM pji_fp_aggr_pjp1 fact
5248: , pji_org_extr_info orginfo
5249: , pji_time_cal_period_v pa_cal
5250: , pji_fm_extr_plnver4 ver
5251: WHERE 1=1
5252: AND fact.CALENDAR_TYPE = 'A'
5253: AND orginfo.org_id = fact.PROJECT_ORG_ID
5254: AND DECODE(p_calendar_type