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

569: , g_default_prg_level prg_level
570: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
571: FROM
572: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
573: , pji_time_CAL_PERIOD period
574: , pji_time_CAL_QTR qtr
575: , pji_fm_extr_plnver3_t ver
576: WHERE
577: fact1.calendar_type = 'P'

Line 818: , pji_time_CAL_PERIOD period

814: , g_default_prg_level prg_level
815: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
816: FROM
817: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
818: , pji_time_CAL_PERIOD period
819: , pji_time_CAL_QTR qtr
820: , pji_fm_extr_plnver3_t ver
821: WHERE
822: fact1.calendar_type = l_calendar_type

Line 1093: , pji_time_CAL_PERIOD period

1089: , g_default_prg_level prg_level
1090: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1091: FROM
1092: PJI_FP_AGGR_PJP1_T fact1
1093: , pji_time_CAL_PERIOD period
1094: , pji_time_CAL_QTR qtr
1095: , pji_fm_extr_plnver3_t ver
1096: WHERE
1097: fact1.calendar_type IN ( l_calendar_type

Line 1215: , pji_time_CAL_PERIOD period

1211: , l_line_type LINE_TYPE
1212: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1213: FROM
1214: PJI_FP_AGGR_PJP1_T fact1
1215: , pji_time_CAL_PERIOD period
1216: , pji_time_CAL_QTR qtr
1217: , pji_fm_extr_plnver3_t ver
1218: WHERE
1219: fact1.calendar_type IN ( p_calendar_type

Line 1909: , pji_time_CAL_PERIOD period

1905: , g_default_prg_level prg_level
1906: , fact1.plan_type_code plan_type_code /* 4471527 */
1907: FROM
1908: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1909: , pji_time_CAL_PERIOD period
1910: , pji_time_CAL_QTR qtr
1911: , pji_fm_extr_plnver3_t ver
1912: WHERE
1913: fact1.calendar_type = 'P'

Line 2152: , pji_time_CAL_PERIOD period

2148: , g_default_prg_level prg_level
2149: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2150: FROM
2151: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2152: , pji_time_CAL_PERIOD period
2153: , pji_time_CAL_QTR qtr
2154: , pji_fm_extr_plnver3_t ver
2155: WHERE
2156: fact1.calendar_type = 'G'

Line 2590: , pji_time_CAL_PERIOD period

2586: , SUM(fact1.CUSTOM15)
2587: , g_default_prg_level prg_level
2588: FROM
2589: pji_ac_aggr_pjp1_t fact1
2590: , pji_time_CAL_PERIOD period
2591: , pji_time_CAL_QTR qtr
2592: WHERE
2593: fact1.calendar_type = 'P'
2594: AND period.cal_period_id = fact1.time_id

Line 2773: , pji_time_CAL_PERIOD period

2769: , SUM(fact1.CUSTOM15)
2770: , g_default_prg_level prg_level
2771: FROM
2772: pji_ac_aggr_pjp1_t fact1
2773: , pji_time_CAL_PERIOD period
2774: , pji_time_CAL_QTR qtr
2775: WHERE
2776: fact1.calendar_type = 'G'
2777: AND period.cal_period_id = fact1.time_id

Line 3156: , pji_time_CAL_PERIOD period

3152: , SUM(fact1.CUSTOM15)
3153: , g_default_prg_level prg_level
3154: FROM
3155: PJI_AC_AGGR_PJP1_T fact1
3156: , pji_time_CAL_PERIOD period
3157: , pji_time_CAL_QTR qtr
3158: WHERE
3159: fact1.calendar_type = p_calendar_type
3160: AND period.cal_period_id = fact1.time_id

Line 4295: , pji_time_cal_period non_pa_cal

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

Line 4575: , pji_time_cal_period_v non_pa_cal

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

Line 5726: , pji_time_cal_period non_pa_cal

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

Line 7389: , pji_time_cal_period non_pa_cal

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

Line 7583: , pji_time_cal_period_v non_pa_cal

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

Line 7793: , pji_time_cal_period non_pa_cal

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

Line 9358: , pji_time_cal_period non_pa_cal

9354: , 'CF' line_type
9355: , fact.time_dangling_flag time_dangling_flag
9356: , fact.rate_dangling_flag rate_dangling_flag
9357: FROM pji_fp_aggr_pjp1_t fact
9358: , pji_time_cal_period non_pa_cal
9359: , pji_org_extr_info orginfo
9360: , pji_time_cal_period pa_cal
9361: , pji_fm_extr_plnver3_t ver
9362: WHERE 1=1

Line 9360: , pji_time_cal_period pa_cal

9356: , fact.rate_dangling_flag rate_dangling_flag
9357: FROM pji_fp_aggr_pjp1_t fact
9358: , pji_time_cal_period non_pa_cal
9359: , pji_org_extr_info orginfo
9360: , pji_time_cal_period pa_cal
9361: , pji_fm_extr_plnver3_t ver
9362: WHERE 1=1
9363: AND fact.CALENDAR_TYPE <> p_calendar_type
9364: AND fact.worker_id = g_worker_id

Line 9649: pji_time_cal_period_v pri

9645: pri.cal_period_id pri_cal_period_id,
9646: sec.cal_period_id sec_cal_period_id,
9647: orginfo.org_id
9648: FROM
9649: pji_time_cal_period_v pri
9650: , pji_org_extr_info orginfo
9651: , pji_time_cal_period_v sec
9652: , pji_fm_extr_plnver3_t ver
9653: , pa_projects_all ppa

Line 9651: , pji_time_cal_period_v sec

9647: orginfo.org_id
9648: FROM
9649: pji_time_cal_period_v pri
9650: , pji_org_extr_info orginfo
9651: , pji_time_cal_period_v sec
9652: , pji_fm_extr_plnver3_t ver
9653: , pa_projects_all ppa
9654: WHERE 1=1
9655: AND ppa.org_id=orginfo.org_id

Line 10826: , pji_time_cal_period non_pa_cal

10822: , NULL rate_dangling_flag
10823: ,fact.plan_type_code plan_type_code /*4471527 */
10824: FROM pji_fp_xbs_accum_f fact
10825: , PJI_FM_EXTR_PLNVER3_T ver
10826: , pji_time_cal_period non_pa_cal
10827: , pji_org_extr_info orginfo
10828: , pji_time_cal_period pa_cal
10829: WHERE 1=1
10830: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 10828: , pji_time_cal_period pa_cal

10824: FROM pji_fp_xbs_accum_f fact
10825: , PJI_FM_EXTR_PLNVER3_T ver
10826: , pji_time_cal_period non_pa_cal
10827: , pji_org_extr_info orginfo
10828: , pji_time_cal_period pa_cal
10829: WHERE 1=1
10830: AND fact.CALENDAR_TYPE <> p_calendar_type
10831: AND fact.CALENDAR_TYPE IN ('P', 'G')
10832: AND non_pa_cal.cal_period_id = fact.time_id

Line 11983: , pji_time_cal_period pa_cal

11979: , NULL time_dangling_flag
11980: , NULL rate_dangling_flag
11981: FROM pji_fp_aggr_pjp1_t fact
11982: , pji_org_extr_info orginfo
11983: , pji_time_cal_period pa_cal
11984: , pji_fm_extr_plnver3_t ver
11985: WHERE 1=1
11986: AND fact.CALENDAR_TYPE = 'A'
11987: AND fact.worker_id = g_worker_id

Line 12274: , pji_time_cal_period_v pa_cal

12270: / (fact.end_date - fact.start_date+1) factor
12271: , fact.plan_type_code plan_type_code /* 4471527 */
12272: FROM pji_fp_aggr_pjp1_t fact
12273: , pji_org_extr_info orginfo
12274: , pji_time_cal_period_v pa_cal
12275: , pji_fm_extr_plnver3_t ver
12276: ,(SELECT currency_code,
12277: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12278: null, 0.01,

Line 12502: , pji_time_cal_period non_pa_cal

12498: , NULL TIME_DANGLING_FLAG
12499: , NULL RATE_DANGLING_FLAG
12500: , g_default_prg_level prg_level
12501: FROM pji_fp_aggr_pjp1_t fact
12502: , pji_time_cal_period non_pa_cal
12503: , pji_org_extr_info orginfo
12504: , pji_time_cal_period pa_cal
12505: , pji_fm_extr_plnver3_t ver
12506: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12504: , pji_time_cal_period pa_cal

12500: , g_default_prg_level prg_level
12501: FROM pji_fp_aggr_pjp1_t fact
12502: , pji_time_cal_period non_pa_cal
12503: , pji_org_extr_info orginfo
12504: , pji_time_cal_period pa_cal
12505: , pji_fm_extr_plnver3_t ver
12506: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12507: AND fact.worker_id = g_worker_id
12508: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 12697: , pji_time_cal_period_v non_pa_cal

12693: , NULL RATE_DANGLING_FLAG
12694: , g_default_prg_level prg_level
12695: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12696: FROM pji_fp_aggr_pjp1_t fact
12697: , pji_time_cal_period_v non_pa_cal
12698: , pji_org_extr_info orginfo
12699: , pji_time_cal_period_v pa_cal
12700: , pji_fm_extr_plnver3_t ver
12701: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12699: , pji_time_cal_period_v pa_cal

12695: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12696: FROM pji_fp_aggr_pjp1_t fact
12697: , pji_time_cal_period_v non_pa_cal
12698: , pji_org_extr_info orginfo
12699: , pji_time_cal_period_v pa_cal
12700: , pji_fm_extr_plnver3_t ver
12701: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12702: AND fact.worker_id = g_worker_id
12703: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 12913: , pji_time_cal_period non_pa_cal

12909: , g_default_prg_level prg_level
12910: , fact.plan_type_code plan_type_code /* 4471527 */
12911: FROM pji_fp_xbs_accum_f fact
12912: , PJI_FM_EXTR_PLNVER3_T ver
12913: , pji_time_cal_period non_pa_cal
12914: , pji_org_extr_info orginfo
12915: , pji_time_cal_period pa_cal
12916: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12917: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 12915: , pji_time_cal_period pa_cal

12911: FROM pji_fp_xbs_accum_f fact
12912: , PJI_FM_EXTR_PLNVER3_T ver
12913: , pji_time_cal_period non_pa_cal
12914: , pji_org_extr_info orginfo
12915: , pji_time_cal_period pa_cal
12916: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12917: AND fact.CALENDAR_TYPE IN ('P', 'G')
12918: AND non_pa_cal.cal_period_id = fact.time_id
12919: AND ver.project_id = fact.project_id

Line 13131: , pji_time_cal_period pa_cal

13127: , NULL RATE_DANGLING_FLAG
13128: , g_default_prg_level prg_level
13129: FROM pji_fp_aggr_pjp1_t fact
13130: , pji_org_extr_info orginfo
13131: , pji_time_cal_period pa_cal
13132: , pji_fm_extr_plnver3_t ver
13133: WHERE 1=1
13134: AND fact.CALENDAR_TYPE = 'A'
13135: AND orginfo.org_id = fact.PROJECT_ORG_ID

Line 13343: , pji_time_cal_period_v pa_cal

13339: , g_default_prg_level prg_level
13340: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
13341: FROM pji_fp_aggr_pjp1_t fact
13342: , pji_org_extr_info orginfo
13343: , pji_time_cal_period_v pa_cal
13344: , pji_fm_extr_plnver3_t ver
13345: WHERE 1=1
13346: AND fact.CALENDAR_TYPE = 'A'
13347: AND orginfo.org_id = fact.PROJECT_ORG_ID