APPS.PJI_FM_SUM_MAIN dependencies on PA_PROJECTS_ALL

Line 295: l_from_project_num pa_projects_all.segment1%TYPE;

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

Line 296: l_to_project_num pa_projects_all.segment1%TYPE;

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

Line 313: from pa_projects_all

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

Line 321: from pa_projects_all

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

Line 329: from pa_projects_all

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

Line 480: PA_PROJECTS_ALL prj

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

Line 558: PA_PROJECTS_ALL prj,

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

Line 565: PA_PROJECTS_ALL prj,

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