DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PJI_FM_AGGR_FIN8

Line 1914: -- This procedure populates PJI_FM_AGGR_FIN8 table

1910: --
1911: -- History
1912: -- 16-JUN-2005 ANAGARAT Created
1913: --
1914: -- This procedure populates PJI_FM_AGGR_FIN8 table
1915: -- for PJI_FM_XBA_ACCUM_UTILS.get_summarized_data () api
1916: -- -----------------------------------------------------
1917:
1918: PROCEDURE POPULATE_FIN8 (p_worker_id IN NUMBER

Line 1935: INSERT INTO pji_fm_aggr_fin8

1931: IF (p_worker_id IS NOT NULL) THEN
1932:
1933: IF ( p_extraction_type='INCREMENTAL' ) THEN
1934:
1935: INSERT INTO pji_fm_aggr_fin8
1936: (
1937: WORKER_ID , RECORD_TYPE , TXN_ACCUM_HEADER_ID ,
1938: RESOURCE_CLASS_ID , PROJECT_ID , PROJECT_ORG_ID ,
1939: PROJECT_ORGANIZATION_ID , PROJECT_TYPE_CLASS , TASK_ID ,

Line 2007: INSERT INTO pji_fm_aggr_fin8

2003: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
2004:
2005: ELSE
2006:
2007: INSERT INTO pji_fm_aggr_fin8
2008: (
2009: TXN_ACCUM_HEADER_ID , RESOURCE_CLASS_ID , PROJECT_ID ,
2010: PROJECT_ORG_ID , PROJECT_ORGANIZATION_ID , PROJECT_TYPE_CLASS ,
2011: TASK_ID , RECVR_PERIOD_TYPE , RECVR_PERIOD_ID ,