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 52: INSERT INTO PJI_FP_AGGR_PJP1

48: BEGIN
49:
50: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
51:
52: INSERT INTO PJI_FP_AGGR_PJP1
53: (
54: WORKER_ID
55: , PRG_LEVEL
56: , PROJECT_ID

Line 219: PJI_FP_AGGR_PJP1 fact1

215: , SUM(CUSTOM15)
216: , 'ENTR'
217: , PLAN_TYPE_CODE /* 4471527 */
218: FROM
219: PJI_FP_AGGR_PJP1 fact1
220: , pji_time_ENT_PERIOD period
221: , pji_time_ENT_QTR qtr
222: WHERE
223: fact1.calendar_type = 'E'

Line 272: INSERT INTO pji_fp_aggr_pjp1

268: BEGIN
269:
270: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
271:
272: INSERT INTO pji_fp_aggr_pjp1
273: (
274: WORKER_ID
275: , PRG_LEVEL
276: , PROJECT_ID

Line 443: pji_fp_aggr_pjp1 fact1

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

Line 491: INSERT INTO pji_fp_aggr_pjp1

487: BEGIN
488:
489: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
490:
491: INSERT INTO pji_fp_aggr_pjp1
492: (
493: WORKER_ID
494: , PRG_LEVEL
495: , PROJECT_ID

Line 663: pji_fp_aggr_pjp1 fact1

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

Line 797: INSERT INTO PJI_FP_AGGR_PJP1

793: AND rhd.project_id = map.project_id);
794: */
795:
796:
797: INSERT INTO PJI_FP_AGGR_PJP1
798: (
799: WORKER_ID
800: , PRG_LEVEL
801: , PROJECT_ID

Line 969: PJI_FP_AGGR_PJP1 fact1

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

Line 1844: INSERT INTO pji_fp_aggr_pjp1

1840:
1841: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1842:
1843: /* Commented for bug 4005006
1844: INSERT INTO pji_fp_aggr_pjp1
1845: (
1846: WORKER_ID
1847: , PRG_LEVEL
1848: , PROJECT_ID

Line 2939: FROM pji_fp_aggr_pjp1 fact

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

Line 2984: INSERT INTO pji_fp_aggr_pjp1

2980: , a.TIME_DANGLING_FLAG
2981: , a.RATE_DANGLING_FLAG;
2982: End of bug 4005006*/
2983:
2984: INSERT INTO pji_fp_aggr_pjp1
2985: (
2986: WORKER_ID
2987: , PROJECT_ID
2988: , PROJECT_ORG_ID

Line 3218: FROM pji_fp_aggr_pjp1 fact

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

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

3292: BEGIN
3293:
3294: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3295:
3296: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.
3297: (
3298: WORKER_ID
3299: , PROJECT_ID
3300: , PROJECT_ORG_ID

Line 3528: FROM pji_fp_aggr_pjp1 fact

3524: , cur.mau mau
3525: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
3526: / (fact.end_date - fact.start_date+1) factor
3527: , fact.plan_type_code plan_type_code /* 4471527 */
3528: FROM pji_fp_aggr_pjp1 fact
3529: , pji_time_ent_period_v entCal
3530: , pji_fm_extr_plnver4 ver
3531: , (SELECT currency_code,
3532: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

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

3590: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3591:
3592: /* Commented for bug 4005006
3593:
3594: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.
3595: (
3596: WORKER_ID
3597: , PROJECT_ID
3598: , PROJECT_ORG_ID

Line 3752: FROM pji_fp_aggr_pjp1 fact

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

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

3789: , fact.TIME_DANGLING_FLAG
3790: , fact.RATE_DANGLING_FLAG;
3791: End of bug 4005006*/
3792:
3793: INSERT INTO pji_fp_aggr_pjp1 -- PA, GL calendar entries.
3794: (
3795: WORKER_ID
3796: , PROJECT_ID
3797: , PROJECT_ORG_ID

Line 3947: FROM pji_fp_aggr_pjp1 fact

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

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

4012: BEGIN
4013:
4014: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4015:
4016: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries.
4017: (
4018: WORKER_ID
4019: , PROJECT_ID
4020: , PROJECT_ORG_ID

Line 4170: FROM pji_fp_aggr_pjp1 fact

4166: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
4167: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4168: , g_default_prg_level prg_level
4169: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4170: FROM pji_fp_aggr_pjp1 fact
4171: , pji_time_ent_period_v pa_cal
4172: , pji_fm_extr_plnver4 ver
4173: WHERE fact.CALENDAR_TYPE = 'A'
4174: AND fact.worker_id = g_worker_id

Line 4227: INSERT INTO pji_fp_aggr_pjp1

4223: BEGIN
4224:
4225: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4226:
4227: INSERT INTO pji_fp_aggr_pjp1
4228: (
4229: worker_id
4230: , PROJECT_ID
4231: , PROJECT_ORG_ID

Line 4458: FROM pji_fp_aggr_pjp1 fact,

4454: , ROUND (nvl(fact.custom15,0)*calDet.factor/cur.mau)*cur.mau custom15
4455: , fact.time_dangling_flag time_dangling_flag
4456: , fact.rate_dangling_flag rate_dangling_flag
4457: , fact.plan_type_code plan_type_code /* 4471527 */
4458: FROM pji_fp_aggr_pjp1 fact,
4459: (SELECT /*+ NO_MERGE */ (LEAST(pri.end_date,sec.end_date) - Greatest(pri.start_date,sec.start_date)+1)
4460: / (pri.end_date - pri.start_date+1) factor,
4461: ppa.project_id,
4462: ver.rbs_struct_Version_id rbs_struct_version_id,

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

4558: END IF;
4559:
4560: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4561:
4562: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..
4563: (
4564: worker_id
4565: , PROJECT_ID
4566: , PROJECT_ORG_ID

Line 4795: FROM pji_fp_aggr_pjp1 fact

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

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

4863: BEGIN
4864:
4865: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4866:
4867: INSERT INTO pji_fp_aggr_pjp1 -- For PA/GL entries.
4868: (
4869: worker_id
4870: , PROJECT_ID
4871: , PROJECT_ORG_ID

Line 5021: FROM pji_fp_aggr_pjp1 fact

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

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

5089: BEGIN
5090:
5091: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5092:
5093: INSERT INTO pji_fp_aggr_pjp1 -- For non time phased entries.
5094: (
5095: worker_id
5096: , PROJECT_ID
5097: , PROJECT_ORG_ID

Line 5247: FROM pji_fp_aggr_pjp1 fact

5243: , NULL TIME_DANGLING_FLAG
5244: , NULL RATE_DANGLING_FLAG
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