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_FP_AGGR_PJP1

Line 59: INSERT INTO PJI_FP_AGGR_PJP1

55: else
56:
57: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
58:
59: INSERT INTO PJI_FP_AGGR_PJP1
60: (
61: WORKER_ID
62: , PRG_LEVEL
63: , PROJECT_ID

Line 226: PJI_FP_AGGR_PJP1 fact1

222: , SUM(CUSTOM15)
223: , 'ENTR'
224: , PLAN_TYPE_CODE /* 4471527 */
225: FROM
226: PJI_FP_AGGR_PJP1 fact1
227: , pji_time_ENT_PERIOD period
228: , pji_time_ENT_QTR qtr
229: WHERE
230: fact1.calendar_type = 'E'

Line 288: INSERT INTO pji_fp_aggr_pjp1

284: else
285:
286: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
287:
288: INSERT INTO pji_fp_aggr_pjp1
289: (
290: WORKER_ID
291: , PRG_LEVEL
292: , PROJECT_ID

Line 459: pji_fp_aggr_pjp1 fact1

455: , SUM(CUSTOM15) CUSTOM15
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'

Line 516: INSERT INTO pji_fp_aggr_pjp1

512: else
513:
514: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
515:
516: INSERT INTO pji_fp_aggr_pjp1
517: (
518: WORKER_ID
519: , PRG_LEVEL
520: , PROJECT_ID

Line 688: pji_fp_aggr_pjp1 fact1

684: , SUM(CUSTOM15) CUSTOM15
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

Line 829: INSERT INTO PJI_FP_AGGR_PJP1

825: AND rhd.project_id = map.project_id);
826: */
827:
828: if p_calendar_type = 'C' then /* Added for bug 11843459 */
829: INSERT INTO PJI_FP_AGGR_PJP1
830: (
831: WORKER_ID
832: , PRG_LEVEL
833: , PROJECT_ID

Line 1001: PJI_FP_AGGR_PJP1 fact1

997: , SUM(CUSTOM15) CUSTOM15
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

Line 1047: INSERT INTO PJI_FP_AGGR_PJP1

1043: WHERE period_type_id = 2048;
1044:
1045: else /* Added for bug 11843459 */
1046:
1047: INSERT INTO PJI_FP_AGGR_PJP1
1048: (
1049: WORKER_ID
1050: , PRG_LEVEL
1051: , PROJECT_ID

Line 1214: PJI_FP_AGGR_PJP1 fact1

1210: , SUM(CUSTOM15) CUSTOM15
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

Line 2091: INSERT INTO pji_fp_aggr_pjp1

2087:
2088: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2089:
2090: /* Commented for bug 4005006
2091: INSERT INTO pji_fp_aggr_pjp1
2092: (
2093: WORKER_ID
2094: , PRG_LEVEL
2095: , PROJECT_ID

Line 3186: FROM pji_fp_aggr_pjp1 fact

3182: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
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')

Line 3231: INSERT INTO pji_fp_aggr_pjp1

3227: , a.TIME_DANGLING_FLAG
3228: , a.RATE_DANGLING_FLAG;
3229: End of bug 4005006*/
3230:
3231: INSERT INTO pji_fp_aggr_pjp1
3232: (
3233: WORKER_ID
3234: , PROJECT_ID
3235: , PROJECT_ORG_ID

Line 3465: FROM pji_fp_aggr_pjp1 fact

3461: , (LEAST(non_pa_cal.end_date,pa_cal.end_date) -
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,

Line 3552: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.

3548: else
3549:
3550: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3551:
3552: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.
3553: (
3554: WORKER_ID
3555: , PROJECT_ID
3556: , PROJECT_ORG_ID

Line 3784: FROM pji_fp_aggr_pjp1 fact

3780: , cur.mau mau
3781: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
3782: / (fact.end_date - fact.start_date+1) factor
3783: , fact.plan_type_code plan_type_code /* 4471527 */
3784: FROM pji_fp_aggr_pjp1 fact
3785: , pji_time_ent_period_v entCal
3786: , pji_fm_extr_plnver4 ver
3787: , (SELECT currency_code,
3788: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 3852: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.

3848: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3849:
3850: /* Commented for bug 4005006
3851:
3852: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.
3853: (
3854: WORKER_ID
3855: , PROJECT_ID
3856: , PROJECT_ORG_ID

Line 4010: FROM pji_fp_aggr_pjp1 fact

4006: , 'CF' line_type
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

Line 4051: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.

4047: , fact.TIME_DANGLING_FLAG
4048: , fact.RATE_DANGLING_FLAG;
4049: End of bug 4005006*/
4050:
4051: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.
4052: (
4053: WORKER_ID
4054: , PROJECT_ID
4055: , PROJECT_ORG_ID

Line 4205: FROM pji_fp_aggr_pjp1 fact

4201: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
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')

Line 4274: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries.

4270: BEGIN
4271:
4272: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4273:
4274: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries.
4275: (
4276: WORKER_ID
4277: , PROJECT_ID
4278: , PROJECT_ORG_ID

Line 4428: FROM pji_fp_aggr_pjp1 fact

4424: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
4425: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4426: , g_default_prg_level prg_level
4427: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4428: FROM pji_fp_aggr_pjp1 fact
4429: , pji_time_ent_period_v pa_cal
4430: , pji_fm_extr_plnver4 ver
4431: WHERE fact.CALENDAR_TYPE = 'A'
4432: AND fact.worker_id = g_worker_id

Line 4492: INSERT INTO pji_fp_aggr_pjp1

4488: else
4489:
4490: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4491:
4492: INSERT INTO pji_fp_aggr_pjp1
4493: (
4494: worker_id
4495: , PROJECT_ID
4496: , PROJECT_ORG_ID

Line 4723: FROM pji_fp_aggr_pjp1 fact,

4719: , ROUND (nvl(fact.custom15,0)*calDet.factor/cur.mau)*cur.mau custom15
4720: , fact.time_dangling_flag time_dangling_flag
4721: , fact.rate_dangling_flag rate_dangling_flag
4722: , fact.plan_type_code plan_type_code /* 4471527 */
4723: FROM pji_fp_aggr_pjp1 fact,
4724: (SELECT /*+ NO_MERGE */ (LEAST(pri.end_date,sec.end_date) - Greatest(pri.start_date,sec.start_date)+1)
4725: / (pri.end_date - pri.start_date+1) factor,
4726: ppa.project_id,
4727: ver.rbs_struct_Version_id rbs_struct_version_id,

Line 4835: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..

4831: END IF;
4832:
4833: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4834:
4835: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..
4836: (
4837: worker_id
4838: , PROJECT_ID
4839: , PROJECT_ORG_ID

Line 5068: FROM pji_fp_aggr_pjp1 fact

5064: , cur.mau mau
5065: , (LEAST(fact.end_date,pa_cal.end_date) - Greatest(fact.start_date,pa_cal.start_date)+1)
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,

Line 5140: INSERT INTO pji_fp_aggr_pjp1 -- For PA/GL entries.

5136: BEGIN
5137:
5138: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5139:
5140: INSERT INTO pji_fp_aggr_pjp1 -- For PA/GL entries.
5141: (
5142: worker_id
5143: , PROJECT_ID
5144: , PROJECT_ORG_ID

Line 5294: FROM pji_fp_aggr_pjp1 fact

5290: , NULL TIME_DANGLING_FLAG
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

Line 5366: INSERT INTO pji_fp_aggr_pjp1 -- For non time phased entries.

5362: BEGIN
5363:
5364: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5365:
5366: INSERT INTO pji_fp_aggr_pjp1 -- For non time phased entries.
5367: (
5368: worker_id
5369: , PROJECT_ID
5370: , PROJECT_ORG_ID

Line 5523: FROM pji_fp_aggr_pjp1 fact

5519: , NULL TIME_DANGLING_FLAG
5520: , NULL RATE_DANGLING_FLAG
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