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 245: , pji_time_ENT_PERIOD period

241: , g_default_prg_level prg_level
242: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
243: FROM
244: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
245: , pji_time_ENT_PERIOD period
246: , pji_time_ENT_QTR qtr
247: , pji_fm_extr_plnver3_t ver
248: WHERE
249: fact1.calendar_type = 'E'

Line 288: from pji_time_ENT_PERIOD

284: begin --Bug 10163571
285: select ent_year_id -- Bug 10305483 -- select ent_year_id instead of ent_period_id
286: ,ent_period_id -- Bug 13365563 --period id also needed
287: into l_entyear_id, l_entperiod_id -- For Bug 10305483
288: from pji_time_ENT_PERIOD
289: where trunc(i.planning_end_date) between
290: trunc(start_date) and trunc(end_date);
291: exception --Bug 10163571
292: when no_data_found then --Bug 10163571

Line 2395: , pji_time_ENT_PERIOD period

2391: , g_default_prg_level prg_level
2392: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2393: FROM
2394: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2395: , pji_time_ENT_PERIOD period
2396: , pji_time_ENT_QTR qtr
2397: , pji_fm_extr_plnver3_t ver
2398: WHERE
2399: fact1.calendar_type = 'E'

Line 2955: , pji_time_ENT_PERIOD period

2951: , SUM(fact1.CUSTOM15)
2952: , g_default_prg_level prg_level
2953: FROM
2954: pji_ac_aggr_pjp1_t fact1
2955: , pji_time_ENT_PERIOD period
2956: , pji_time_ENT_QTR qtr
2957: WHERE
2958: fact1.calendar_type = 'E'
2959: AND period.ENT_period_id = fact1.time_id

Line 4296: , pji_time_ent_period pa_cal

4292: , fact.rate_dangling_flag rate_dangling_flag
4293: , g_default_prg_level prg_level
4294: FROM pji_fp_aggr_pjp1_t fact
4295: , pji_time_cal_period non_pa_cal
4296: , pji_time_ent_period pa_cal
4297: , pji_fm_extr_plnver3_t ver
4298: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4299: AND fact.worker_id = g_worker_id
4300: AND non_pa_cal.cal_period_id = fact.time_id

Line 4576: , pji_time_ent_period_v pa_cal

4572: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4573: , fact.plan_type_code plan_type_code /* 4471527 */
4574: FROM pji_fp_aggr_pjp1_t fact
4575: , pji_time_cal_period_v non_pa_cal
4576: , pji_time_ent_period_v pa_cal
4577: , pji_fm_extr_plnver3_t ver
4578: , (SELECT currency_code,
4579: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4580: null, 0.01,

Line 5728: , pji_time_ent_period pa_cal

5724: , fact.plan_type_code plan_type_code /* 4471527 */
5725: FROM pji_fp_xbs_accum_f fact
5726: , pji_time_cal_period non_pa_cal
5727: -- , pji_org_extr_info orginfo
5728: , pji_time_ent_period pa_cal
5729: , PJI_FM_EXTR_PLNVER3_T ver
5730: WHERE 1 = 1
5731: AND fact.calendar_type IN ('P', 'G')
5732: AND fact.period_type_id = 32

Line 6882: , pji_time_ent_period pa_cal

6878: , fact.time_dangling_flag time_dangling_flag
6879: , fact.rate_dangling_flag rate_dangling_flag
6880: , g_default_prg_level prg_level
6881: FROM pji_fp_aggr_pjp1_t fact
6882: , pji_time_ent_period pa_cal
6883: , pji_fm_extr_plnver3_t ver
6884: WHERE 1=1
6885: AND fact.CALENDAR_TYPE = 'A'
6886: AND fact.worker_id = g_worker_id

Line 7167: , pji_time_ent_period_v entCal

7163: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
7164: / (fact.end_date - fact.start_date+1) factor
7165: , fact.plan_type_code plan_type_code /* 4471527 */
7166: FROM pji_fp_aggr_pjp1_t fact
7167: , pji_time_ent_period_v entCal
7168: , pji_fm_extr_plnver3_t ver
7169: , (SELECT currency_code,
7170: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7171: null, 0.01,

Line 7391: , pji_time_ent_period pa_cal

7387: , g_default_prg_level prg_level
7388: FROM pji_fp_aggr_pjp1_t fact
7389: , pji_time_cal_period non_pa_cal
7390: -- , pji_org_extr_info orginfo
7391: , pji_time_ent_period pa_cal
7392: , pji_fm_extr_plnver3_t ver
7393: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7394: AND fact.worker_id = g_worker_id
7395: AND non_pa_cal.cal_period_id = fact.time_id

Line 7584: , pji_time_ent_period_v pa_cal

7580: , g_default_prg_level prg_level
7581: , fact.plan_type_code plan_type_code /* 4471527 */
7582: FROM pji_fp_aggr_pjp1_t fact
7583: , pji_time_cal_period_v non_pa_cal
7584: , pji_time_ent_period_v pa_cal
7585: , pji_fm_extr_plnver3_t ver
7586: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7587: AND fact.worker_id = g_worker_id
7588: AND non_pa_cal.cal_period_id = fact.time_id

Line 7795: , pji_time_ent_period pa_cal

7791: FROM pji_fp_xbs_accum_f fact
7792: , PJI_FM_EXTR_PLNVER3_T ver
7793: , pji_time_cal_period non_pa_cal
7794: -- , pji_org_extr_info orginfo
7795: , pji_time_ent_period pa_cal
7796: WHERE non_pa_cal.cal_period_id = fact.time_id
7797: AND fact.period_type_id = 32
7798: AND ver.project_id = fact.project_id
7799: AND ver.plan_version_id = fact.plan_version_id

Line 7999: , pji_time_ent_period pa_cal

7995: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7996: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7997: , g_default_prg_level prg_level
7998: FROM pji_fp_aggr_pjp1_t fact
7999: , pji_time_ent_period pa_cal
8000: , pji_fm_extr_plnver3_t ver
8001: WHERE fact.CALENDAR_TYPE = 'A'
8002: AND fact.worker_id = g_worker_id
8003: AND fact.line_type = 'NTP'

Line 8205: , pji_time_ent_period_v pa_cal

8201: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
8202: , g_default_prg_level prg_level
8203: , fact.plan_type_code plan_type_code /* 4471527 */
8204: FROM pji_fp_aggr_pjp1_t fact
8205: , pji_time_ent_period_v pa_cal
8206: , pji_fm_extr_plnver3_t ver
8207: WHERE fact.CALENDAR_TYPE = 'A'
8208: AND fact.worker_id = g_worker_id
8209: AND fact.line_type = 'NTP'