APPS.PJI_FM_SUM_MAIN dependencies on PA_PROJECTS_ALL

Line 294: l_from_project_num pa_projects_all.segment1%TYPE;

290: l_extraction_type varchar2(30);
291: p_from_project_id number ;
292: p_to_project_id number ;
293: l_count number ;
294: l_from_project_num pa_projects_all.segment1%TYPE;
295: l_to_project_num pa_projects_all.segment1%TYPE;
296: l_invalid_parameter varchar2(255) := 'The specified range of projects is invalid, To Project should be greater than From Project ';
297: l_no_work varchar2(255) := 'There is no project to process for the specified parameters';
298:

Line 295: l_to_project_num pa_projects_all.segment1%TYPE;

291: p_from_project_id number ;
292: p_to_project_id number ;
293: l_count number ;
294: l_from_project_num pa_projects_all.segment1%TYPE;
295: l_to_project_num pa_projects_all.segment1%TYPE;
296: l_invalid_parameter varchar2(255) := 'The specified range of projects is invalid, To Project should be greater than From Project ';
297: l_no_work varchar2(255) := 'There is no project to process for the specified parameters';
298:
299: begin

Line 312: from pa_projects_all

308: IF p_from_project is not null
309: or p_to_project is not null then
310: select min(segment1) ,max(segment1)
311: into l_from_project_num, l_to_project_num
312: from pa_projects_all
313: where segment1 between nvl(p_from_project,segment1) and nvl(p_to_project,segment1);
314:
315: END if;
316: /* Get the Project Ids ,this is required to keep the impact minimum , these values will be updated in pji_system_parameters Table */

Line 320: from pa_projects_all

316: /* Get the Project Ids ,this is required to keep the impact minimum , these values will be updated in pji_system_parameters Table */
317: IF l_from_project_num is not null THEN
318: select project_id
319: into p_from_project_id
320: from pa_projects_all
321: where segment1= l_from_project_num;
322: else
323: p_from_project_id:=-1;
324: END IF;

Line 328: from pa_projects_all

324: END IF;
325: IF l_to_project_num is not null THEN
326: select project_id
327: into p_to_project_id
328: from pa_projects_all
329: where segment1= l_to_project_num;
330: else
331: p_to_project_id:=-1;
332: END IF;

Line 479: PA_PROJECTS_ALL prj

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',
483: 'PENDING_PURGE') and

Line 557: PA_PROJECTS_ALL prj,

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

Line 564: PA_PROJECTS_ALL prj,

560: distinct
561: emt.PROJECT_ID
562: from
563: PA_PROJECT_STATUSES stat,
564: PA_PROJECTS_ALL prj,
565: PA_XBS_DENORM prg,
566: PA_PROJ_ELEMENTS emt
567: where
568: stat.STATUS_TYPE = 'PROJECT' and