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_TIME_CAL_PERIOD

Line 444: , pji_time_CAL_PERIOD period

440: , l_line_type line_type
441: , fact1.plan_type_code plan_type_code /* 4471527 */
442: FROM
443: pji_fp_aggr_pjp1 fact1
444: , pji_time_CAL_PERIOD period
445: , pji_time_CAL_QTR qtr
446: WHERE
447: fact1.calendar_type = 'P'
448: AND period.cal_period_id = fact1.time_id

Line 664: , pji_time_CAL_PERIOD period

660: , l_line_type
661: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
662: FROM
663: pji_fp_aggr_pjp1 fact1
664: , pji_time_CAL_PERIOD period
665: , pji_time_CAL_QTR qtr
666: WHERE
667: fact1.calendar_type = l_calendar_type
668: AND period.cal_period_id = fact1.time_id

Line 970: , pji_time_CAL_PERIOD period

966: ,l_line_type
967: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
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

Line 1231: , pji_time_CAL_PERIOD period

1227: , SUM(fact1.CUSTOM14)
1228: , SUM(fact1.CUSTOM15)
1229: FROM
1230: PJI_AC_AGGR_PJP1 fact1
1231: , pji_time_CAL_PERIOD period
1232: , pji_time_CAL_QTR qtr
1233: WHERE
1234: fact1.calendar_type = 'P'
1235: AND period.cal_period_id = fact1.time_id

Line 1414: , pji_time_CAL_PERIOD period

1410: , SUM(fact1.CUSTOM14)
1411: , SUM(fact1.CUSTOM15)
1412: FROM
1413: PJI_AC_AGGR_PJP1 fact1
1414: , pji_time_CAL_PERIOD period
1415: , pji_time_CAL_QTR qtr
1416: WHERE
1417: fact1.calendar_type = 'G'
1418: AND period.cal_period_id = fact1.time_id

Line 1802: , pji_time_CAL_PERIOD period

1798: , SUM(fact1.CUSTOM14)
1799: , SUM(fact1.CUSTOM15)
1800: FROM
1801: PJI_AC_AGGR_PJP1 fact1
1802: , pji_time_CAL_PERIOD period
1803: , pji_time_CAL_QTR qtr
1804: WHERE
1805: fact1.calendar_type = p_calendar_type
1806: AND period.cal_period_id = fact1.time_id

Line 2940: , pji_time_cal_period non_pa_cal

2936: , 'CF' line_type
2937: , fact.time_dangling_flag time_dangling_flag
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

Line 3219: , pji_time_cal_period_v non_pa_cal

3215: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
3216: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
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))),

Line 3753: , pji_time_cal_period non_pa_cal

3749: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
3750: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
3751: , g_default_prg_level PRG_LEVEL
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')

Line 3948: , pji_time_cal_period_v non_pa_cal

3944: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
3945: , g_default_prg_level prg_level
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

Line 4469: pji_time_cal_period_v pri

4465: pri.cal_period_id pri_cal_period_id,
4466: sec.cal_period_id sec_cal_period_id,
4467: orginfo.org_id
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

Line 4471: , pji_time_cal_period_v sec

4467: orginfo.org_id
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

Line 4797: , pji_time_cal_period_v pa_cal

4793: / (fact.end_date - fact.start_date+1) factor
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,

Line 5022: , pji_time_cal_period_v non_pa_cal

5018: , NULL RATE_DANGLING_FLAG
5019: , g_default_prg_level prg_level
5020: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
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

Line 5024: , pji_time_cal_period_v pa_cal

5020: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
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

Line 5249: , pji_time_cal_period_v pa_cal

5245: , g_default_prg_level prg_level
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