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 460: , pji_time_CAL_PERIOD period

456: , l_line_type line_type
457: , fact1.plan_type_code plan_type_code /* 4471527 */
458: FROM
459: pji_fp_aggr_pjp1 fact1
460: , pji_time_CAL_PERIOD period
461: , pji_time_CAL_QTR qtr
462: WHERE
463: fact1.calendar_type = 'P'
464: AND period.cal_period_id = fact1.time_id

Line 689: , pji_time_CAL_PERIOD period

685: , l_line_type
686: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
687: FROM
688: pji_fp_aggr_pjp1 fact1
689: , pji_time_CAL_PERIOD period
690: , pji_time_CAL_QTR qtr
691: WHERE
692: fact1.calendar_type = l_calendar_type
693: AND period.cal_period_id = fact1.time_id

Line 1002: , pji_time_CAL_PERIOD period

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

Line 1215: , pji_time_CAL_PERIOD period

1211: ,l_line_type
1212: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE
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

Line 1471: , pji_time_CAL_PERIOD period

1467: , SUM(fact1.CUSTOM14)
1468: , SUM(fact1.CUSTOM15)
1469: FROM
1470: PJI_AC_AGGR_PJP1 fact1
1471: , pji_time_CAL_PERIOD period
1472: , pji_time_CAL_QTR qtr
1473: WHERE
1474: fact1.calendar_type = 'P'
1475: AND period.cal_period_id = fact1.time_id

Line 1654: , pji_time_CAL_PERIOD period

1650: , SUM(fact1.CUSTOM14)
1651: , SUM(fact1.CUSTOM15)
1652: FROM
1653: PJI_AC_AGGR_PJP1 fact1
1654: , pji_time_CAL_PERIOD period
1655: , pji_time_CAL_QTR qtr
1656: WHERE
1657: fact1.calendar_type = 'G'
1658: AND period.cal_period_id = fact1.time_id

Line 2042: , pji_time_CAL_PERIOD period

2038: , SUM(fact1.CUSTOM14)
2039: , SUM(fact1.CUSTOM15)
2040: FROM
2041: PJI_AC_AGGR_PJP1 fact1
2042: , pji_time_CAL_PERIOD period
2043: , pji_time_CAL_QTR qtr
2044: WHERE
2045: fact1.calendar_type = p_calendar_type
2046: AND period.cal_period_id = fact1.time_id

Line 3187: , pji_time_cal_period non_pa_cal

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

Line 3466: , pji_time_cal_period_v non_pa_cal

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

Line 4011: , pji_time_cal_period non_pa_cal

4007: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
4008: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4009: , g_default_prg_level PRG_LEVEL
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')

Line 4206: , pji_time_cal_period_v non_pa_cal

4202: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4203: , g_default_prg_level prg_level
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

Line 4734: pji_time_cal_period_v pri

4730: pri.cal_period_id pri_cal_period_id,
4731: sec.cal_period_id sec_cal_period_id,
4732: orginfo.org_id
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

Line 4736: , pji_time_cal_period_v sec

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

Line 5070: , pji_time_cal_period_v pa_cal

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

Line 5295: , pji_time_cal_period_v non_pa_cal

5291: , NULL RATE_DANGLING_FLAG
5292: , g_default_prg_level prg_level
5293: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
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

Line 5297: , pji_time_cal_period_v pa_cal

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

Line 5525: , pji_time_cal_period_v pa_cal

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