APPS.PJI_FM_SUM_MAIN dependencies on PJI_PROJ_EXTR_STATUS

Line 337: from PJI_PROJ_EXTR_STATUS

333: END IF;
334:
335: select count(*)
336: into l_project_count
337: from PJI_PROJ_EXTR_STATUS
338: where ROWNUM = 1;
339:
340: if (p_run_mode = 'F') then
341: l_extraction_type := 'FULL';

Line 410: -- PJI_PROJ_EXTR_STATUS

406:
407: -- Update list of organizations to be extracted in case
408: -- users defined new organizations.
409: -- List of organizations is stored in table
410: -- PJI_PROJ_EXTR_STATUS
411: -- at the end of processing a batch the summarization
412: -- process should update the pji_project_status field. This
413: -- should be done by the last extraction process for the
414: -- batch.

Line 479: PJI_PROJ_EXTR_STATUS extr,

475: prj.CLOSED_DATE,
476: 'N',
477: 'N'
478: from
479: PJI_PROJ_EXTR_STATUS extr,
480: PA_PROJECTS_ALL prj
481: where
482: nvl(extr.PURGE_STATUS,'X') not in ('PARTIALLY_PURGED',
483: 'PURGED',

Line 557: PJI_PROJ_EXTR_STATUS status,

553: prj.CLOSED_DATE,
554: 'N',
555: 'N'
556: from
557: PJI_PROJ_EXTR_STATUS status,
558: PA_PROJECTS_ALL prj,
559: (
560: select /*+ ordered */
561: distinct

Line 645: update PJI_PROJ_EXTR_STATUS

641: -- Bug#5099574 ends
642:
643:
644:
645: update PJI_PROJ_EXTR_STATUS
646: set EXTRACTION_STATUS = 'X',
647: LAST_UPDATE_DATE = sysdate
648: where l_extraction_type <> 'PARTIAL' and
649: EXTRACTION_STATUS is null and