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_T dependencies on PJI_TIME_ENT_PERIOD

Line 220: , pji_time_ENT_PERIOD period

216: , g_default_prg_level prg_level
217: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
218: FROM
219: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
220: , pji_time_ENT_PERIOD period
221: , pji_time_ENT_QTR qtr
222: , pji_fm_extr_plnver3_t ver
223: WHERE
224: fact1.calendar_type = 'E'

Line 2257: , pji_time_ENT_PERIOD period

2253: , g_default_prg_level prg_level
2254: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2255: FROM
2256: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2257: , pji_time_ENT_PERIOD period
2258: , pji_time_ENT_QTR qtr
2259: , pji_fm_extr_plnver3_t ver
2260: WHERE
2261: fact1.calendar_type = 'E'

Line 2817: , pji_time_ENT_PERIOD period

2813: , SUM(fact1.CUSTOM15)
2814: , g_default_prg_level prg_level
2815: FROM
2816: pji_ac_aggr_pjp1_t fact1
2817: , pji_time_ENT_PERIOD period
2818: , pji_time_ENT_QTR qtr
2819: WHERE
2820: fact1.calendar_type = 'E'
2821: AND period.ENT_period_id = fact1.time_id

Line 4158: , pji_time_ent_period pa_cal

4154: , fact.rate_dangling_flag rate_dangling_flag
4155: , g_default_prg_level prg_level
4156: FROM pji_fp_aggr_pjp1_t fact
4157: , pji_time_cal_period non_pa_cal
4158: , pji_time_ent_period pa_cal
4159: , pji_fm_extr_plnver3_t ver
4160: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4161: AND fact.worker_id = g_worker_id
4162: AND non_pa_cal.cal_period_id = fact.time_id

Line 4438: , pji_time_ent_period_v pa_cal

4434: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4435: , fact.plan_type_code plan_type_code /* 4471527 */
4436: FROM pji_fp_aggr_pjp1_t fact
4437: , pji_time_cal_period_v non_pa_cal
4438: , pji_time_ent_period_v pa_cal
4439: , pji_fm_extr_plnver3_t ver
4440: , (SELECT currency_code,
4441: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4442: null, 0.01,

Line 5590: , pji_time_ent_period pa_cal

5586: , fact.plan_type_code plan_type_code /* 4471527 */
5587: FROM pji_fp_xbs_accum_f fact
5588: , pji_time_cal_period non_pa_cal
5589: -- , pji_org_extr_info orginfo
5590: , pji_time_ent_period pa_cal
5591: , PJI_FM_EXTR_PLNVER3_T ver
5592: WHERE 1 = 1
5593: AND fact.calendar_type IN ('P', 'G')
5594: AND fact.period_type_id = 32

Line 6744: , pji_time_ent_period pa_cal

6740: , fact.time_dangling_flag time_dangling_flag
6741: , fact.rate_dangling_flag rate_dangling_flag
6742: , g_default_prg_level prg_level
6743: FROM pji_fp_aggr_pjp1_t fact
6744: , pji_time_ent_period pa_cal
6745: , pji_fm_extr_plnver3_t ver
6746: WHERE 1=1
6747: AND fact.CALENDAR_TYPE = 'A'
6748: AND fact.worker_id = g_worker_id

Line 7029: , pji_time_ent_period_v entCal

7025: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
7026: / (fact.end_date - fact.start_date+1) factor
7027: , fact.plan_type_code plan_type_code /* 4471527 */
7028: FROM pji_fp_aggr_pjp1_t fact
7029: , pji_time_ent_period_v entCal
7030: , pji_fm_extr_plnver3_t ver
7031: , (SELECT currency_code,
7032: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7033: null, 0.01,

Line 7253: , pji_time_ent_period pa_cal

7249: , g_default_prg_level prg_level
7250: FROM pji_fp_aggr_pjp1_t fact
7251: , pji_time_cal_period non_pa_cal
7252: -- , pji_org_extr_info orginfo
7253: , pji_time_ent_period pa_cal
7254: , pji_fm_extr_plnver3_t ver
7255: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7256: AND fact.worker_id = g_worker_id
7257: AND non_pa_cal.cal_period_id = fact.time_id

Line 7446: , pji_time_ent_period_v pa_cal

7442: , g_default_prg_level prg_level
7443: , fact.plan_type_code plan_type_code /* 4471527 */
7444: FROM pji_fp_aggr_pjp1_t fact
7445: , pji_time_cal_period_v non_pa_cal
7446: , pji_time_ent_period_v pa_cal
7447: , pji_fm_extr_plnver3_t ver
7448: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7449: AND fact.worker_id = g_worker_id
7450: AND non_pa_cal.cal_period_id = fact.time_id

Line 7657: , pji_time_ent_period pa_cal

7653: FROM pji_fp_xbs_accum_f fact
7654: , PJI_FM_EXTR_PLNVER3_T ver
7655: , pji_time_cal_period non_pa_cal
7656: -- , pji_org_extr_info orginfo
7657: , pji_time_ent_period pa_cal
7658: WHERE non_pa_cal.cal_period_id = fact.time_id
7659: AND fact.period_type_id = 32
7660: AND ver.project_id = fact.project_id
7661: AND ver.plan_version_id = fact.plan_version_id

Line 7861: , pji_time_ent_period pa_cal

7857: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7858: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7859: , g_default_prg_level prg_level
7860: FROM pji_fp_aggr_pjp1_t fact
7861: , pji_time_ent_period pa_cal
7862: , pji_fm_extr_plnver3_t ver
7863: WHERE fact.CALENDAR_TYPE = 'A'
7864: AND fact.worker_id = g_worker_id
7865: AND fact.line_type = 'NTP'

Line 8067: , pji_time_ent_period_v pa_cal

8063: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
8064: , g_default_prg_level prg_level
8065: , fact.plan_type_code plan_type_code /* 4471527 */
8066: FROM pji_fp_aggr_pjp1_t fact
8067: , pji_time_ent_period_v pa_cal
8068: , pji_fm_extr_plnver3_t ver
8069: WHERE fact.CALENDAR_TYPE = 'A'
8070: AND fact.worker_id = g_worker_id
8071: AND fact.line_type = 'NTP'