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.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_FM_EXTR_PLNVER4

Line 774: INSERT INTO PJI_FM_EXTR_PLNVER4

770: END IF;
771: END IF;*/
772:
773: /*
774: INSERT INTO PJI_FM_EXTR_PLNVER4
775: (
776: WORKER_ID ,
777: PROJECT_ID ,
778: PLAN_VERSION_ID ,

Line 1004: , pji_fm_extr_plnver4 ver

1000: FROM
1001: PJI_FP_AGGR_PJP1 fact1
1002: , pji_time_CAL_PERIOD period
1003: , pji_time_CAL_QTR qtr
1004: , pji_fm_extr_plnver4 ver
1005: WHERE
1006: -- cal type changes for bug 6381284
1007: --fact1.calendar_type = p_calendar_type
1008: fact1.calendar_type in ( p_calendar_type

Line 1217: , pji_fm_extr_plnver4 ver

1213: FROM
1214: PJI_FP_AGGR_PJP1 fact1
1215: , pji_time_CAL_PERIOD period
1216: , pji_time_CAL_QTR qtr
1217: , pji_fm_extr_plnver4 ver
1218: WHERE
1219: fact1.calendar_type = p_calendar_type
1220: AND period.cal_period_id = fact1.time_id
1221: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1252: -- DELETE FROM PJI_FM_EXTR_PLNVER4

1248: , fact1.PLAN_TYPE_CODE )
1249: WHERE period_type_id = 2048;
1250:
1251: end if; /* Added for bug 11843459 */
1252: -- DELETE FROM PJI_FM_EXTR_PLNVER4
1253: -- WHERE plan_version_id = -1
1254: -- AND worker_id = g_worker_id;
1255:
1256: end if;

Line 3189: , pji_fm_extr_plnver4 ver

3185: , fact.rate_dangling_flag rate_dangling_flag
3186: FROM pji_fp_aggr_pjp1 fact
3187: , pji_time_cal_period non_pa_cal
3188: , pji_time_ent_period pa_cal
3189: , pji_fm_extr_plnver4 ver
3190: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3191: AND fact.worker_id = g_worker_id
3192: AND non_pa_cal.cal_period_id = fact.time_id
3193: AND fact.line_type like 'OF%'

Line 3468: , pji_fm_extr_plnver4 ver

3464: , fact.plan_type_code plan_type_code /* 4471527 */
3465: FROM pji_fp_aggr_pjp1 fact
3466: , pji_time_cal_period_v non_pa_cal
3467: , pji_time_ent_period_v pa_cal
3468: , pji_fm_extr_plnver4 ver
3469: , (SELECT currency_code,
3470: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3471: null, 0.01,
3472: 0, 1,

Line 3786: , pji_fm_extr_plnver4 ver

3782: / (fact.end_date - fact.start_date+1) factor
3783: , fact.plan_type_code plan_type_code /* 4471527 */
3784: FROM pji_fp_aggr_pjp1 fact
3785: , pji_time_ent_period_v entCal
3786: , pji_fm_extr_plnver4 ver
3787: , (SELECT currency_code,
3788: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3789: null, 0.01,
3790: 0, 1,

Line 4014: , pji_fm_extr_plnver4 ver

4010: FROM pji_fp_aggr_pjp1 fact
4011: , pji_time_cal_period non_pa_cal
4012: -- , pji_org_extr_info orginfo
4013: , pji_time_ent_period pa_cal
4014: , pji_fm_extr_plnver4 ver
4015: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4016: AND fact.worker_id = g_worker_id
4017: AND ver.worker_id = g_worker_id
4018: AND non_pa_cal.cal_period_id = fact.time_id

Line 4208: , pji_fm_extr_plnver4 ver

4204: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4205: FROM pji_fp_aggr_pjp1 fact
4206: , pji_time_cal_period_v non_pa_cal
4207: , pji_time_ent_period_v pa_cal
4208: , pji_fm_extr_plnver4 ver
4209: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4210: AND fact.worker_id = g_worker_id
4211: AND ver.worker_id = g_worker_id
4212: AND non_pa_cal.cal_period_id = fact.time_id

Line 4430: , pji_fm_extr_plnver4 ver

4426: , g_default_prg_level prg_level
4427: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4428: FROM pji_fp_aggr_pjp1 fact
4429: , pji_time_ent_period_v pa_cal
4430: , pji_fm_extr_plnver4 ver
4431: WHERE fact.CALENDAR_TYPE = 'A'
4432: AND fact.worker_id = g_worker_id
4433: AND ver.worker_id = g_worker_id
4434: AND fact.line_type = 'NTP'

Line 4737: , pji_fm_extr_plnver4 ver

4733: FROM
4734: pji_time_cal_period_v pri
4735: , pji_org_extr_info orginfo
4736: , pji_time_cal_period_v sec
4737: , pji_fm_extr_plnver4 ver
4738: , pa_projects_all ppa
4739: WHERE 1=1
4740: AND ppa.org_id=orginfo.org_id
4741: AND ver.worker_id = g_worker_id

Line 5071: , pji_fm_extr_plnver4 ver

5067: , fact.plan_type_code plan_type_code /* 4471527 */
5068: FROM pji_fp_aggr_pjp1 fact
5069: , pji_org_extr_info orginfo
5070: , pji_time_cal_period_v pa_cal
5071: , pji_fm_extr_plnver4 ver
5072: ,(SELECT currency_code,
5073: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
5074: null, 0.01,
5075: 0, 1,

Line 5298: , pji_fm_extr_plnver4 ver

5294: FROM pji_fp_aggr_pjp1 fact
5295: , pji_time_cal_period_v non_pa_cal
5296: , pji_org_extr_info orginfo
5297: , pji_time_cal_period_v pa_cal
5298: , pji_fm_extr_plnver4 ver
5299: WHERE fact.CALENDAR_TYPE <> p_calendar_type
5300: AND fact.worker_id = g_worker_id
5301: AND ver.worker_id = g_worker_id
5302: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 5526: , pji_fm_extr_plnver4 ver

5522: , fact.plan_type_code PLAN_TYPE_CODE /* 4471527 */
5523: FROM pji_fp_aggr_pjp1 fact
5524: , pji_org_extr_info orginfo
5525: , pji_time_cal_period_v pa_cal
5526: , pji_fm_extr_plnver4 ver
5527: WHERE 1=1
5528: AND fact.CALENDAR_TYPE = 'A'
5529: AND orginfo.org_id = fact.PROJECT_ORG_ID
5530: AND DECODE(p_calendar_type