APPS.PJI_FM_SUM_MAIN dependencies on PJI_PROJ_EXTR_STATUS

Line 336: from PJI_PROJ_EXTR_STATUS

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

Line 409: -- PJI_PROJ_EXTR_STATUS

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

Line 478: PJI_PROJ_EXTR_STATUS extr,

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

Line 556: PJI_PROJ_EXTR_STATUS status,

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

Line 644: update PJI_PROJ_EXTR_STATUS

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