APPS.PJI_RM_SUM_AVL dependencies on PJI_RM_AGGR_AVL5

Line 1570: INSERT INTO PJI_RM_AGGR_AVL5

1566: --Insert this is AVL5 table so that we can pick up
1567: --the values from this table in the second run after
1568: --changes are applied to the fact table
1569:
1570: INSERT INTO PJI_RM_AGGR_AVL5
1571: (
1572: EXPENDITURE_ORG_ID,
1573: PERSON_ID,
1574: CALENDAR_TYPE,

Line 1612: FROM PJI_RM_AGGR_AVL5 avl5

1608: avl5.gl_calendar_id as gl_calendar_id,
1609: avl5.period_type_id as period_type_id,
1610: avl5.period_id as period_id,
1611: avl5.period_type as period_type
1612: FROM PJI_RM_AGGR_AVL5 avl5
1613: WHERE avl5.person_id = p_person_id;
1614: END IF;
1615:
1616: /*PHASE 2*/

Line 4462: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL5');

4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');
4459:
4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');
4461:
4462: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL5');
4463:
4464: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_RES_BATCH_MAP');
4465:
4466: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION