DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PJI_FM_AGGR_FIN8

Line 1974: -- This procedure populates PJI_FM_AGGR_FIN8 table

1970: --
1971: -- History
1972: -- 16-JUN-2005 ANAGARAT Created
1973: --
1974: -- This procedure populates PJI_FM_AGGR_FIN8 table
1975: -- for PJI_FM_XBA_ACCUM_UTILS.get_summarized_data () api
1976: -- -----------------------------------------------------
1977:
1978: PROCEDURE POPULATE_FIN8 (p_worker_id IN NUMBER

Line 1995: INSERT INTO pji_fm_aggr_fin8

1991: IF (p_worker_id IS NOT NULL) THEN
1992:
1993: IF ( p_extraction_type='INCREMENTAL' ) THEN
1994:
1995: INSERT INTO pji_fm_aggr_fin8
1996: (
1997: WORKER_ID , RECORD_TYPE , TXN_ACCUM_HEADER_ID ,
1998: RESOURCE_CLASS_ID , PROJECT_ID , PROJECT_ORG_ID ,
1999: PROJECT_ORGANIZATION_ID , PROJECT_TYPE_CLASS , TASK_ID ,

Line 2069: INSERT INTO pji_fm_aggr_fin8

2065: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
2066:
2067: ELSE
2068:
2069: INSERT INTO pji_fm_aggr_fin8
2070: (
2071: TXN_ACCUM_HEADER_ID , RESOURCE_CLASS_ID , PROJECT_ID ,
2072: PROJECT_ORG_ID , PROJECT_ORGANIZATION_ID , PROJECT_TYPE_CLASS ,
2073: TASK_ID , RECVR_PERIOD_TYPE , RECVR_PERIOD_ID ,