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_FP_AGGR_PJP1_T

Line 52: INSERT INTO PJI_FP_AGGR_PJP1_T

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

Line 219: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

215: , 'ENTR'
216: , g_default_prg_level prg_level
217: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
218: FROM
219: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
220: , pji_time_ENT_PERIOD period
221: , pji_time_ENT_QTR qtr
222: , pji_fm_extr_plnver3_t ver
223: WHERE

Line 280: INSERT INTO pji_fp_aggr_pjp1_t

276: BEGIN
277:
278: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
279:
280: INSERT INTO pji_fp_aggr_pjp1_t
281: (
282: WORKER_ID
283: , PROJECT_ID
284: , PROJECT_ORG_ID

Line 451: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

447: , l_line_type line_type
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

Line 518: INSERT INTO pji_fp_aggr_pjp1_t

514: BEGIN
515:
516: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
517:
518: INSERT INTO pji_fp_aggr_pjp1_t
519: (
520: WORKER_ID
521: , PROJECT_ID
522: , PROJECT_ORG_ID

Line 696: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

692: , l_line_type
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

Line 785: INSERT INTO PJI_FP_AGGR_PJP1_T

781: null;
782: end ;
783: IF l_time_phase_change = 0 THEN
784:
785: INSERT INTO PJI_FP_AGGR_PJP1_T
786: (
787: WORKER_ID
788: , PROJECT_ID
789: , PROJECT_ORG_ID

Line 954: PJI_FP_AGGR_PJP1_T fact1

950: ,l_line_type
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

Line 1000: MERGE INTO PJI_FP_AGGR_PJP1_T F1

996: ELSE
997: /* 4604617 */
998: /*When Time phase change from PA/GL to None then update the existing A lines
999: When Gl to PA or vice versa , insert only one -A lines */
1000: MERGE INTO PJI_FP_AGGR_PJP1_T F1
1001: USING ( SELECT g_worker_id WORKER_ID
1002: , fact1.PROJECT_ID
1003: , fact1.PROJECT_ORG_ID
1004: , fact1.PROJECT_ORGANIZATION_ID

Line 1076: PJI_FP_AGGR_PJP1_T fact1

1072: , g_default_prg_level PRG_LEVEL
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

Line 1364: INSERT INTO pji_fp_aggr_pjp1_t

1360: BEGIN
1361:
1362: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1363:
1364: INSERT INTO pji_fp_aggr_pjp1_t
1365: (
1366: WORKER_ID
1367: , PRG_LEVEL
1368: , PROJECT_ID

Line 1518: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

1514: , SUM(CUSTOM15) CUSTOM15
1515: , l_line_type
1516: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1517: FROM
1518: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1519: , pji_fm_extr_plnver3_t ver
1520: WHERE
1521: fact1.calendar_type = l_calendar_type
1522: AND fact1.period_type_id = l_period_type_id

Line 1587: INSERT INTO pji_fp_aggr_pjp1_t

1583: BEGIN
1584:
1585: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1586:
1587: INSERT INTO pji_fp_aggr_pjp1_t
1588: (
1589: WORKER_ID
1590: , PROJECT_ID
1591: , PROJECT_ORG_ID

Line 1770: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

1766: , 'PAR'
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

Line 1830: INSERT INTO pji_fp_aggr_pjp1_t

1826: BEGIN
1827:
1828: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1829:
1830: INSERT INTO pji_fp_aggr_pjp1_t
1831: (
1832: WORKER_ID
1833: , PROJECT_ID
1834: , PROJECT_ORG_ID

Line 2013: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

2009: , 'GLR'
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

Line 2073: INSERT INTO pji_fp_aggr_pjp1_t

2069: BEGIN
2070:
2071: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2072:
2073: INSERT INTO pji_fp_aggr_pjp1_t
2074: (
2075: WORKER_ID
2076: , PROJECT_ID
2077: , PROJECT_ORG_ID

Line 2256: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

2252: , 'ENTR'
2253: , g_default_prg_level prg_level
2254: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2255: FROM
2256: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2257: , pji_time_ENT_PERIOD period
2258: , pji_time_ENT_QTR qtr
2259: , pji_fm_extr_plnver3_t ver
2260: WHERE

Line 3060: INSERT INTO pji_fp_aggr_pjp1_t

3056:
3057: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3058:
3059: /* Commented for bug 4005006
3060: INSERT INTO pji_fp_aggr_pjp1_t
3061: (
3062: WORKER_ID
3063: , PROJECT_ID
3064: , PROJECT_ORG_ID

Line 4156: FROM pji_fp_aggr_pjp1_t fact

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

Line 4202: INSERT INTO pji_fp_aggr_pjp1_t

4198: , a.TIME_DANGLING_FLAG
4199: , a.RATE_DANGLING_FLAG;
4200: End of 4005006*/
4201:
4202: INSERT INTO pji_fp_aggr_pjp1_t
4203: (
4204: WORKER_ID
4205: , PROJECT_ID
4206: , PROJECT_ORG_ID

Line 4436: FROM pji_fp_aggr_pjp1_t fact

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

Line 4498: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries in FP Reporting lines.

4494: BEGIN
4495:
4496: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4497:
4498: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries in FP Reporting lines.
4499: (
4500: WORKER_ID
4501: , PROJECT_ID
4502: , PROJECT_ORG_ID

Line 5647: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.

5643:
5644: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5645:
5646: /* Commented for bug 4005006
5647: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.
5648: (
5649: WORKER_ID
5650: , PROJECT_ID
5651: , PROJECT_ORG_ID

Line 6743: FROM pji_fp_aggr_pjp1_t fact

6739: , 'CN' line_type
6740: , fact.time_dangling_flag time_dangling_flag
6741: , fact.rate_dangling_flag rate_dangling_flag
6742: , g_default_prg_level prg_level
6743: FROM pji_fp_aggr_pjp1_t fact
6744: , pji_time_ent_period pa_cal
6745: , pji_fm_extr_plnver3_t ver
6746: WHERE 1=1
6747: AND fact.CALENDAR_TYPE = 'A'

Line 6796: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.

6792: , a.TIME_DANGLING_FLAG
6793: , a.RATE_DANGLING_FLAG;
6794: End of 4005006*/
6795:
6796: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.
6797: (
6798: WORKER_ID
6799: , PROJECT_ID
6800: , PROJECT_ORG_ID

Line 7028: FROM pji_fp_aggr_pjp1_t fact

7024: , cur.mau mau
7025: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
7026: / (fact.end_date - fact.start_date+1) factor
7027: , fact.plan_type_code plan_type_code /* 4471527 */
7028: FROM pji_fp_aggr_pjp1_t fact
7029: , pji_time_ent_period_v entCal
7030: , pji_fm_extr_plnver3_t ver
7031: , (SELECT currency_code,
7032: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 7092: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.

7088:
7089: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7090:
7091: /* Commented for bug 4005006
7092: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7093: (
7094: WORKER_ID
7095: , PROJECT_ID
7096: , PROJECT_ORG_ID

Line 7250: FROM pji_fp_aggr_pjp1_t fact

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

Line 7290: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.

7286: , fact.TIME_DANGLING_FLAG
7287: , fact.RATE_DANGLING_FLAG;
7288: End of bug 4005006*/
7289:
7290: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7291: (
7292: WORKER_ID
7293: , PROJECT_ID
7294: , PROJECT_ORG_ID

Line 7444: FROM pji_fp_aggr_pjp1_t fact

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

Line 7499: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.

7495: BEGIN
7496:
7497: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7498:
7499: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7500: (
7501: WORKER_ID
7502: , PROJECT_ID
7503: , PROJECT_ORG_ID

Line 7704: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.

7700: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7701:
7702: /* Commented for bug 4005006
7703:
7704: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.
7705: (
7706: WORKER_ID
7707: , PROJECT_ID
7708: , PROJECT_ORG_ID

Line 7860: FROM pji_fp_aggr_pjp1_t fact

7856: , 'CN' line_type
7857: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7858: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7859: , g_default_prg_level prg_level
7860: FROM pji_fp_aggr_pjp1_t fact
7861: , pji_time_ent_period pa_cal
7862: , pji_fm_extr_plnver3_t ver
7863: WHERE fact.CALENDAR_TYPE = 'A'
7864: AND fact.worker_id = g_worker_id

Line 7912: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.

7908: , fact.RATE_DANGLING_FLAG;
7909:
7910: End of bug 4005006*/
7911:
7912: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.
7913: (
7914: WORKER_ID
7915: , PROJECT_ID
7916: , PROJECT_ORG_ID

Line 8066: FROM pji_fp_aggr_pjp1_t fact

8062: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
8063: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
8064: , g_default_prg_level prg_level
8065: , fact.plan_type_code plan_type_code /* 4471527 */
8066: FROM pji_fp_aggr_pjp1_t fact
8067: , pji_time_ent_period_v pa_cal
8068: , pji_fm_extr_plnver3_t ver
8069: WHERE fact.CALENDAR_TYPE = 'A'
8070: AND fact.worker_id = g_worker_id

Line 8124: INSERT INTO pji_fp_aggr_pjp1_t

8120:
8121: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
8122:
8123: /* Commented for bug 4005006
8124: INSERT INTO pji_fp_aggr_pjp1_t
8125: (
8126: worker_id
8127: , PROJECT_ID
8128: , PROJECT_ORG_ID

Line 9219: FROM pji_fp_aggr_pjp1_t fact

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

Line 9269: INSERT INTO pji_fp_aggr_pjp1_t

9265: , a.TIME_DANGLING_FLAG
9266: , a.RATE_DANGLING_FLAG;
9267: End for 4005006*/
9268:
9269: INSERT INTO pji_fp_aggr_pjp1_t
9270: (
9271: worker_id
9272: , PROJECT_ID
9273: , PROJECT_ORG_ID

Line 9500: FROM pji_fp_aggr_pjp1_t fact,

9496: , ROUND (nvl(fact.custom15,0)*calDet.factor/cur.mau)*cur.mau custom15
9497: , fact.time_dangling_flag time_dangling_flag
9498: , fact.rate_dangling_flag rate_dangling_flag
9499: , fact.plan_type_code plan_type_code /* 4471527 */
9500: FROM pji_fp_aggr_pjp1_t fact,
9501: (SELECT /*+ NO_MERGE */ (LEAST(pri.end_date,sec.end_date) - Greatest(pri.start_date,sec.start_date)+1)
9502: / (pri.end_date - pri.start_date+1) factor,
9503: ppa.project_id,
9504: ver.rbs_struct_Version_id rbs_struct_version_id,

Line 9588: INSERT INTO pji_fp_aggr_pjp1_t

9584: BEGIN
9585:
9586: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
9587:
9588: INSERT INTO pji_fp_aggr_pjp1_t
9589: (
9590: worker_id
9591: , PROJECT_ID
9592: , PROJECT_ORG_ID

Line 10749: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..

10745:
10746: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
10747:
10748: /* Commented for bug 4005006
10749: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..
10750: (
10751: worker_id
10752: , PROJECT_ID
10753: , PROJECT_ORG_ID

Line 11843: FROM pji_fp_aggr_pjp1_t fact

11839: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
11840: , 'CF' line_type
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

Line 11902: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..

11898: , a.RATE_DANGLING_FLAG;
11899:
11900: End for 4005006 */
11901:
11902: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..
11903: (
11904: worker_id
11905: , PROJECT_ID
11906: , PROJECT_ORG_ID

Line 12134: FROM pji_fp_aggr_pjp1_t fact

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

Line 12205: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.

12201:
12202: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12203:
12204: /* Commented for bug 4005006
12205: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12206: (
12207: worker_id
12208: , PROJECT_ID
12209: , PROJECT_ORG_ID

Line 12363: FROM pji_fp_aggr_pjp1_t fact

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

Line 12404: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.

12400: , fact.PLAN_TYPE_ID ;
12401:
12402: End of bug 4005006*/
12403:
12404: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12405: (
12406: worker_id
12407: , PROJECT_ID
12408: , PROJECT_ORG_ID

Line 12558: FROM pji_fp_aggr_pjp1_t fact

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

Line 12613: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.

12609: BEGIN
12610:
12611: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12612:
12613: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12614: (
12615: worker_id
12616: , PROJECT_ID
12617: , PROJECT_ORG_ID

Line 12832: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.

12828: END IF;
12829:
12830: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12831: /* Commented for bug 4005006
12832: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.
12833: (
12834: worker_id
12835: , PROJECT_ID
12836: , PROJECT_ORG_ID

Line 12991: FROM pji_fp_aggr_pjp1_t fact

12987: , 'CN' line_type
12988: , NULL TIME_DANGLING_FLAG
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

Line 13049: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.

13045: orginfo.pa_calendar_id,
13046: orginfo.gl_calendar_id;
13047: End of bug 4005006*/
13048:
13049: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.
13050: (
13051: worker_id
13052: , PROJECT_ID
13053: , PROJECT_ORG_ID

Line 13203: FROM pji_fp_aggr_pjp1_t fact

13199: , NULL TIME_DANGLING_FLAG
13200: , NULL RATE_DANGLING_FLAG
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