APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_AC_AGGR_PJP1

Line 1328: INSERT INTO PJI_AC_AGGR_PJP1

1324: BEGIN
1325:
1326: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1327:
1328: INSERT INTO PJI_AC_AGGR_PJP1
1329: (
1330: WORKER_ID
1331: , PRG_LEVEL
1332: , PROJECT_ID

Line 1470: PJI_AC_AGGR_PJP1 fact1

1466: , SUM(fact1.CUSTOM13)
1467: , SUM(fact1.CUSTOM14)
1468: , SUM(fact1.CUSTOM15)
1469: FROM
1470: PJI_AC_AGGR_PJP1 fact1
1471: , pji_time_CAL_PERIOD period
1472: , pji_time_CAL_QTR qtr
1473: WHERE
1474: fact1.calendar_type = 'P'

Line 1511: INSERT INTO PJI_AC_AGGR_PJP1

1507: BEGIN
1508:
1509: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1510:
1511: INSERT INTO PJI_AC_AGGR_PJP1
1512: (
1513: worker_id
1514: , PRG_LEVEL
1515: , PROJECT_ID

Line 1653: PJI_AC_AGGR_PJP1 fact1

1649: , SUM(fact1.CUSTOM13)
1650: , SUM(fact1.CUSTOM14)
1651: , SUM(fact1.CUSTOM15)
1652: FROM
1653: PJI_AC_AGGR_PJP1 fact1
1654: , pji_time_CAL_PERIOD period
1655: , pji_time_CAL_QTR qtr
1656: WHERE
1657: fact1.calendar_type = 'G'

Line 1693: INSERT INTO PJI_AC_AGGR_PJP1

1689: BEGIN
1690:
1691: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1692:
1693: INSERT INTO PJI_AC_AGGR_PJP1
1694: (
1695: worker_id
1696: , PRG_LEVEL
1697: , PROJECT_ID

Line 1835: PJI_AC_AGGR_PJP1 fact1

1831: , SUM(fact1.CUSTOM13)
1832: , SUM(fact1.CUSTOM14)
1833: , SUM(fact1.CUSTOM15)
1834: FROM
1835: PJI_AC_AGGR_PJP1 fact1
1836: , pji_time_ENT_PERIOD period
1837: , pji_time_ENT_QTR qtr
1838: WHERE
1839: fact1.calendar_type = 'E'

Line 1896: INSERT INTO PJI_AC_AGGR_PJP1

1892: END IF;
1893:
1894: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1895:
1896: INSERT INTO PJI_AC_AGGR_PJP1
1897: (
1898: worker_id
1899: , PRG_LEVEL
1900: , PROJECT_ID

Line 2041: PJI_AC_AGGR_PJP1 fact1

2037: , SUM(fact1.CUSTOM13)
2038: , SUM(fact1.CUSTOM14)
2039: , SUM(fact1.CUSTOM15)
2040: FROM
2041: PJI_AC_AGGR_PJP1 fact1
2042: , pji_time_CAL_PERIOD period
2043: , pji_time_CAL_QTR qtr
2044: WHERE
2045: fact1.calendar_type = p_calendar_type