APPS.PJI_RM_SUM_MAIN dependencies on PA_PROJECTS_ALL

Line 333: l_from_project_num pa_projects_all.segment1%TYPE;

329: l_project_count number;
330: p_from_project_id number;
331: p_to_project_id number;
332: l_count number;
333: l_from_project_num pa_projects_all.segment1%TYPE;
334: l_to_project_num pa_projects_all.segment1%TYPE;
335: l_invalid_parameter varchar2(255) := 'The specified range of projects is invalid, To Project should be greater than From Project ';
336: l_no_work varchar2(255) := 'There is no project to process for the specified parameters';
337:

Line 334: l_to_project_num pa_projects_all.segment1%TYPE;

330: p_from_project_id number;
331: p_to_project_id number;
332: l_count number;
333: l_from_project_num pa_projects_all.segment1%TYPE;
334: l_to_project_num pa_projects_all.segment1%TYPE;
335: l_invalid_parameter varchar2(255) := 'The specified range of projects is invalid, To Project should be greater than From Project ';
336: l_no_work varchar2(255) := 'There is no project to process for the specified parameters';
337:
338: begin

Line 642: from pa_projects_all

638: select min(segment1),
639: max(segment1)
640: into l_from_project_num,
641: l_to_project_num
642: from pa_projects_all
643: where segment1 between nvl(p_from_project,segment1) and
644: nvl(p_to_project,segment1);
645:
646: END if;

Line 652: from pa_projects_all

648: IF (l_from_project_num is not null) THEN
649:
650: select project_id
651: into p_from_project_id
652: from pa_projects_all
653: where segment1= l_from_project_num;
654:
655: else
656:

Line 665: from pa_projects_all

661: IF l_to_project_num is not null THEN
662:
663: select project_id
664: into p_to_project_id
665: from pa_projects_all
666: where segment1= l_to_project_num;
667:
668: else
669:

Line 739: PA_PROJECTS_ALL prj

735: 'N',
736: 'N'
737: from
738: PJI_PJI_PROJ_EXTR_STATUS extr,
739: PA_PROJECTS_ALL prj
740: where
741: extr.project_id = prj.project_id and
742: nvl(prj.org_id,-99) = nvl(p_operating_unit,nvl(prj.org_id,-99)) and
743: (l_extraction_type = 'FULL' or