APPS.PJI_FM_EXTR dependencies on PJI_FM_EXTR_FUNDG

Line 24: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_FUNDG

20: end if;
21:
22: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
23:
24: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_FUNDG
25: (
26: worker_id
27: ,project_org_id
28: ,project_organization_id

Line 204: PJI_FM_EXTR_FUNDG

200: BATCH_ID,
201: null,
202: null
203: from
204: PJI_FM_EXTR_FUNDG
205: where
206: PJI_SUMMARIZED_FLAG is not null;
207:
208: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 279: from PJI_FM_EXTR_FUNDG fnd

275: update pa_project_fundings
276: set pji_summarized_flag = NULL
277: where rowid in (select /*+ cardinality(fnd, 1) */
278: fnd.row_id
279: from PJI_FM_EXTR_FUNDG fnd
280: where fnd.pji_summarized_flag is not null and
281: fnd.batch_id = l_helper_batch_id);
282:
283: update PJI_HELPER_BATCH_MAP

Line 3774: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);

3770: begin
3771:
3772: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3773:
3774: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);
3775:
3776: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);
3777:
3778: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);