APPS.PJI_RM_SUM_AVL dependencies on PJI_RM_AGGR_AVL1

Line 1438: delete from PJI_RM_AGGR_AVL1 where worker_id = p_worker_id;

1434: EXPENDITURE_ORGANIZATION_ID;
1435:
1436: BEGIN
1437:
1438: delete from PJI_RM_AGGR_AVL1 where worker_id = p_worker_id;
1439: delete from PJI_RM_AGGR_AVL2 where worker_id = p_worker_id;
1440:
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: savepoint before_calc_starts;

Line 1465: INSERT INTO PJI_RM_AGGR_AVL1

1461:
1462: IF (p_run_mode = 'OLD_FACT_RECORDS') THEN
1463:
1464: --Insert into TMP1 table
1465: INSERT INTO PJI_RM_AGGR_AVL1
1466: (
1467: EXPENDITURE_ORG_ID,
1468: WORKER_ID,
1469: PERSON_ID,

Line 1588: FROM PJI_RM_AGGR_AVL1 avl1;

1584: avl1.gl_calendar_id as gl_calendar_id,
1585: avl1.period_type_id as period_type_id,
1586: avl1.period_id as period_id,
1587: avl1.period_type as period_type
1588: FROM PJI_RM_AGGR_AVL1 avl1;
1589: ELSE
1590: --This is for the next run when changes
1591: --have been applied to the fact table
1592: INSERT INTO PJI_RM_AGGR_AVL1

Line 1592: INSERT INTO PJI_RM_AGGR_AVL1

1588: FROM PJI_RM_AGGR_AVL1 avl1;
1589: ELSE
1590: --This is for the next run when changes
1591: --have been applied to the fact table
1592: INSERT INTO PJI_RM_AGGR_AVL1
1593: (
1594: EXPENDITURE_ORG_ID,
1595: WORKER_ID,
1596: PERSON_ID,

Line 1736: PJI_RM_AGGR_AVL1 avl_tmp1,

1732: 0 as ROLL_X_WEEK_11,
1733: 0 as ROLL_X_WEEK_12,
1734: 0 as ROLL_X_WEEK_13
1735: FROM
1736: PJI_RM_AGGR_AVL1 avl_tmp1,
1737: FII_TIME_DAY fiit
1738: WHERE
1739: avl_tmp1.PERIOD_ID = fiit.ENT_QTR_ID
1740: and avl_tmp1.period_type_id = 64

Line 1768: PJI_RM_AGGR_AVL1 avl_tmp1,

1764: 0 as ROLL_X_WEEK_11,
1765: 0 as ROLL_X_WEEK_12,
1766: 0 as ROLL_X_WEEK_13
1767: FROM
1768: PJI_RM_AGGR_AVL1 avl_tmp1,
1769: FII_TIME_CAL_PERIOD per,
1770: FII_TIME_CAL_DAY_MV fiit
1771: WHERE
1772: avl_tmp1.PERIOD_ID = per.CAL_QTR_ID

Line 1867: PJI_RM_AGGR_AVL1 w

1863: , DECODE(sign(g_no_of_roll_week-10),1,1-abs(sign( FLOOR((w.period_id-( (FLOOR(( w.period_id + rw.offset - 10 + g_no_of_roll_week )/g_no_of_roll_week)-1) * g_no_of_roll_week + 10 ))/g_no_of_roll_week) )),null) rw11_flag
1864: , DECODE(sign(g_no_of_roll_week-11),1,1-abs(sign( FLOOR((w.period_id-( (FLOOR(( w.period_id + rw.offset - 11 + g_no_of_roll_week )/g_no_of_roll_week)-1) * g_no_of_roll_week + 11 ))/g_no_of_roll_week) )),null) rw12_flag
1865: , DECODE(sign(g_no_of_roll_week-12),1,1-abs(sign( FLOOR((w.period_id-( (FLOOR(( w.period_id + rw.offset - 12 + g_no_of_roll_week )/g_no_of_roll_week)-1) * g_no_of_roll_week + 12 ))/g_no_of_roll_week) )),null) rw13_flag
1866: FROM
1867: PJI_RM_AGGR_AVL1 w
1868: , PJI_ROLL_WEEK_OFFSET rw
1869: WHERE
1870: w.period_type = 'W'
1871: and w.worker_id = p_worker_id

Line 4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');

4450: )) THEN
4451: RETURN;
4452: END IF;
4453:
4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');
4455:
4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');
4457:
4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');