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_CAL_PERIOD

Line 452: , pji_time_CAL_PERIOD period

448: , g_default_prg_level prg_level
449: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
450: FROM
451: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
452: , pji_time_CAL_PERIOD period
453: , pji_time_CAL_QTR qtr
454: , pji_fm_extr_plnver3_t ver
455: WHERE
456: fact1.calendar_type = 'P'

Line 697: , pji_time_CAL_PERIOD period

693: , g_default_prg_level prg_level
694: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
695: FROM
696: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
697: , pji_time_CAL_PERIOD period
698: , pji_time_CAL_QTR qtr
699: , pji_fm_extr_plnver3_t ver
700: WHERE
701: fact1.calendar_type = l_calendar_type

Line 955: , pji_time_CAL_PERIOD period

951: , g_default_prg_level prg_level
952: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
953: FROM
954: PJI_FP_AGGR_PJP1_T fact1
955: , pji_time_CAL_PERIOD period
956: , pji_time_CAL_QTR qtr
957: , pji_fm_extr_plnver3_t ver
958: WHERE
959: fact1.calendar_type IN ( p_calendar_type

Line 1077: , pji_time_CAL_PERIOD period

1073: , l_line_type LINE_TYPE
1074: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1075: FROM
1076: PJI_FP_AGGR_PJP1_T fact1
1077: , pji_time_CAL_PERIOD period
1078: , pji_time_CAL_QTR qtr
1079: , pji_fm_extr_plnver3_t ver
1080: WHERE
1081: fact1.calendar_type IN ( p_calendar_type

Line 1771: , pji_time_CAL_PERIOD period

1767: , g_default_prg_level prg_level
1768: , fact1.plan_type_code plan_type_code /* 4471527 */
1769: FROM
1770: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1771: , pji_time_CAL_PERIOD period
1772: , pji_time_CAL_QTR qtr
1773: , pji_fm_extr_plnver3_t ver
1774: WHERE
1775: fact1.calendar_type = 'P'

Line 2014: , pji_time_CAL_PERIOD period

2010: , g_default_prg_level prg_level
2011: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2012: FROM
2013: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2014: , pji_time_CAL_PERIOD period
2015: , pji_time_CAL_QTR qtr
2016: , pji_fm_extr_plnver3_t ver
2017: WHERE
2018: fact1.calendar_type = 'G'

Line 2452: , pji_time_CAL_PERIOD period

2448: , SUM(fact1.CUSTOM15)
2449: , g_default_prg_level prg_level
2450: FROM
2451: pji_ac_aggr_pjp1_t fact1
2452: , pji_time_CAL_PERIOD period
2453: , pji_time_CAL_QTR qtr
2454: WHERE
2455: fact1.calendar_type = 'P'
2456: AND period.cal_period_id = fact1.time_id

Line 2635: , pji_time_CAL_PERIOD period

2631: , SUM(fact1.CUSTOM15)
2632: , g_default_prg_level prg_level
2633: FROM
2634: pji_ac_aggr_pjp1_t fact1
2635: , pji_time_CAL_PERIOD period
2636: , pji_time_CAL_QTR qtr
2637: WHERE
2638: fact1.calendar_type = 'G'
2639: AND period.cal_period_id = fact1.time_id

Line 3018: , pji_time_CAL_PERIOD period

3014: , SUM(fact1.CUSTOM15)
3015: , g_default_prg_level prg_level
3016: FROM
3017: PJI_AC_AGGR_PJP1_T fact1
3018: , pji_time_CAL_PERIOD period
3019: , pji_time_CAL_QTR qtr
3020: WHERE
3021: fact1.calendar_type = p_calendar_type
3022: AND period.cal_period_id = fact1.time_id

Line 4157: , pji_time_cal_period non_pa_cal

4153: , fact.time_dangling_flag time_dangling_flag
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

Line 4437: , pji_time_cal_period_v non_pa_cal

4433: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
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))),

Line 5588: , pji_time_cal_period non_pa_cal

5584: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
5585: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
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

Line 7251: , pji_time_cal_period non_pa_cal

7247: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7248: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
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')

Line 7445: , pji_time_cal_period_v non_pa_cal

7441: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
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

Line 7655: , pji_time_cal_period non_pa_cal

7651: , g_default_prg_level prg_level
7652: , fact.plan_type_code plan_type_code /* 4471527 */
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

Line 9220: , pji_time_cal_period non_pa_cal

9216: , 'CF' line_type
9217: , fact.time_dangling_flag time_dangling_flag
9218: , fact.rate_dangling_flag rate_dangling_flag
9219: FROM pji_fp_aggr_pjp1_t fact
9220: , pji_time_cal_period non_pa_cal
9221: , pji_org_extr_info orginfo
9222: , pji_time_cal_period pa_cal
9223: , pji_fm_extr_plnver3_t ver
9224: WHERE 1=1

Line 9222: , pji_time_cal_period pa_cal

9218: , fact.rate_dangling_flag rate_dangling_flag
9219: FROM pji_fp_aggr_pjp1_t fact
9220: , pji_time_cal_period non_pa_cal
9221: , pji_org_extr_info orginfo
9222: , pji_time_cal_period pa_cal
9223: , pji_fm_extr_plnver3_t ver
9224: WHERE 1=1
9225: AND fact.CALENDAR_TYPE <> p_calendar_type
9226: AND fact.worker_id = g_worker_id

Line 9511: pji_time_cal_period_v pri

9507: pri.cal_period_id pri_cal_period_id,
9508: sec.cal_period_id sec_cal_period_id,
9509: orginfo.org_id
9510: FROM
9511: pji_time_cal_period_v pri
9512: , pji_org_extr_info orginfo
9513: , pji_time_cal_period_v sec
9514: , pji_fm_extr_plnver3_t ver
9515: , pa_projects_all ppa

Line 9513: , pji_time_cal_period_v sec

9509: orginfo.org_id
9510: FROM
9511: pji_time_cal_period_v pri
9512: , pji_org_extr_info orginfo
9513: , pji_time_cal_period_v sec
9514: , pji_fm_extr_plnver3_t ver
9515: , pa_projects_all ppa
9516: WHERE 1=1
9517: AND ppa.org_id=orginfo.org_id

Line 10688: , pji_time_cal_period non_pa_cal

10684: , NULL rate_dangling_flag
10685: ,fact.plan_type_code plan_type_code /*4471527 */
10686: FROM pji_fp_xbs_accum_f fact
10687: , PJI_FM_EXTR_PLNVER3_T ver
10688: , pji_time_cal_period non_pa_cal
10689: , pji_org_extr_info orginfo
10690: , pji_time_cal_period pa_cal
10691: WHERE 1=1
10692: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 10690: , pji_time_cal_period pa_cal

10686: FROM pji_fp_xbs_accum_f fact
10687: , PJI_FM_EXTR_PLNVER3_T ver
10688: , pji_time_cal_period non_pa_cal
10689: , pji_org_extr_info orginfo
10690: , pji_time_cal_period pa_cal
10691: WHERE 1=1
10692: AND fact.CALENDAR_TYPE <> p_calendar_type
10693: AND fact.CALENDAR_TYPE IN ('P', 'G')
10694: AND non_pa_cal.cal_period_id = fact.time_id

Line 11845: , pji_time_cal_period pa_cal

11841: , NULL time_dangling_flag
11842: , NULL rate_dangling_flag
11843: FROM pji_fp_aggr_pjp1_t fact
11844: , pji_org_extr_info orginfo
11845: , pji_time_cal_period pa_cal
11846: , pji_fm_extr_plnver3_t ver
11847: WHERE 1=1
11848: AND fact.CALENDAR_TYPE = 'A'
11849: AND fact.worker_id = g_worker_id

Line 12136: , pji_time_cal_period_v pa_cal

12132: / (fact.end_date - fact.start_date+1) factor
12133: , fact.plan_type_code plan_type_code /* 4471527 */
12134: FROM pji_fp_aggr_pjp1_t fact
12135: , pji_org_extr_info orginfo
12136: , pji_time_cal_period_v pa_cal
12137: , pji_fm_extr_plnver3_t ver
12138: ,(SELECT currency_code,
12139: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12140: null, 0.01,

Line 12364: , pji_time_cal_period non_pa_cal

12360: , NULL TIME_DANGLING_FLAG
12361: , NULL RATE_DANGLING_FLAG
12362: , g_default_prg_level prg_level
12363: FROM pji_fp_aggr_pjp1_t fact
12364: , pji_time_cal_period non_pa_cal
12365: , pji_org_extr_info orginfo
12366: , pji_time_cal_period pa_cal
12367: , pji_fm_extr_plnver3_t ver
12368: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12366: , pji_time_cal_period pa_cal

12362: , g_default_prg_level prg_level
12363: FROM pji_fp_aggr_pjp1_t fact
12364: , pji_time_cal_period non_pa_cal
12365: , pji_org_extr_info orginfo
12366: , pji_time_cal_period pa_cal
12367: , pji_fm_extr_plnver3_t ver
12368: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12369: AND fact.worker_id = g_worker_id
12370: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 12559: , pji_time_cal_period_v non_pa_cal

12555: , NULL RATE_DANGLING_FLAG
12556: , g_default_prg_level prg_level
12557: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12558: FROM pji_fp_aggr_pjp1_t fact
12559: , pji_time_cal_period_v non_pa_cal
12560: , pji_org_extr_info orginfo
12561: , pji_time_cal_period_v pa_cal
12562: , pji_fm_extr_plnver3_t ver
12563: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12561: , pji_time_cal_period_v pa_cal

12557: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12558: FROM pji_fp_aggr_pjp1_t fact
12559: , pji_time_cal_period_v non_pa_cal
12560: , pji_org_extr_info orginfo
12561: , pji_time_cal_period_v pa_cal
12562: , pji_fm_extr_plnver3_t ver
12563: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12564: AND fact.worker_id = g_worker_id
12565: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 12775: , pji_time_cal_period non_pa_cal

12771: , g_default_prg_level prg_level
12772: , fact.plan_type_code plan_type_code /* 4471527 */
12773: FROM pji_fp_xbs_accum_f fact
12774: , PJI_FM_EXTR_PLNVER3_T ver
12775: , pji_time_cal_period non_pa_cal
12776: , pji_org_extr_info orginfo
12777: , pji_time_cal_period pa_cal
12778: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12779: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 12777: , pji_time_cal_period pa_cal

12773: FROM pji_fp_xbs_accum_f fact
12774: , PJI_FM_EXTR_PLNVER3_T ver
12775: , pji_time_cal_period non_pa_cal
12776: , pji_org_extr_info orginfo
12777: , pji_time_cal_period pa_cal
12778: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12779: AND fact.CALENDAR_TYPE IN ('P', 'G')
12780: AND non_pa_cal.cal_period_id = fact.time_id
12781: AND ver.project_id = fact.project_id

Line 12993: , pji_time_cal_period pa_cal

12989: , NULL RATE_DANGLING_FLAG
12990: , g_default_prg_level prg_level
12991: FROM pji_fp_aggr_pjp1_t fact
12992: , pji_org_extr_info orginfo
12993: , pji_time_cal_period pa_cal
12994: , pji_fm_extr_plnver3_t ver
12995: WHERE 1=1
12996: AND fact.CALENDAR_TYPE = 'A'
12997: AND orginfo.org_id = fact.PROJECT_ORG_ID

Line 13205: , pji_time_cal_period_v pa_cal

13201: , g_default_prg_level prg_level
13202: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
13203: FROM pji_fp_aggr_pjp1_t fact
13204: , pji_org_extr_info orginfo
13205: , pji_time_cal_period_v pa_cal
13206: , pji_fm_extr_plnver3_t ver
13207: WHERE 1=1
13208: AND fact.CALENDAR_TYPE = 'A'
13209: AND orginfo.org_id = fact.PROJECT_ORG_ID