APPS.PA_EXT_ATTRIBUTE_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	   SELECT
	     attr_group_disp_name
	     FROM
	     EGO_OBJ_ATTR_GRP_ASSOCS_V AGV
	     WHERE 	     AGV.classification_code =  p_classfication_code;

Line: 64

	  select
	    display_name
	    From EGO_PAGES_V
	    where classification_code = p_classfication_code;

Line: 115

     SELECT
       epv.page_id
       FROM PA_PROJECT_DRIVERS_V pprv,
       ego_pages_v epv,
       fnd_objects fo
       where pprv.project_id = p_object_id
       AND fo.obj_name = 'PA_PROJECTS'
       and epv.object_id = fo.object_id and epv.object_name = 'PA_PROJECTS'
       and pprv.driver_code = epv.classification_code
       and epv.data_level_int_name = 'PROJECT_LEVEL'
       AND epv.page_id = p_page_id;

Line: 129

     	select project_id from pa_proj_elements
	where proj_element_id =  p_object_id
	  AND object_type = 'PA_TASKS'
	  ;

Line: 137

     SELECT
       epv.page_id
       FROM
       PA_PROJECTS_ALL PPA,
       PA_PROJECT_TYPES_ALL PPT,
       ego_pages_v epv,
       fnd_objects fo
       where ppa.project_id = l_project_id
       AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
       AND PPA.ORG_ID = PPT.ORG_ID   -- Bug 5900445
       AND fo.obj_name = 'PA_PROJECTS'
       and epv.object_id = fo.object_id and epv.object_name = 'PA_PROJECTS'
       and 'PROJECT_TYPE:' || PPT.PROJECT_TYPE_ID = epv.classification_code
       and epv.data_level_int_name = 'TASK_LEVEL'
       AND epv.page_id = p_page_id
union
SELECT
       epv.page_id
       FROM
       PA_PROJECT_CLASSES PPC,
       PA_CLASS_CATEGORIES PCC,
       ego_pages_v epv,
       fnd_objects fo
       where
       PPC.PROJECT_ID = l_project_id
       AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
       AND fo.obj_name = 'PA_PROJECTS'
       and epv.object_id = fo.object_id and epv.object_name = 'PA_PROJECTS'
       and 'CLASS_CATEGORY:' || PCC.CLASS_CATEGORY_ID  = epv.classification_code
       and epv.data_level_int_name = 'TASK_LEVEL'
       AND epv.page_id = p_page_id
union
SELECT
       epv.page_id
       FROM
       PA_PROJECT_CLASSES PPC,
       PA_CLASS_CODES pcc,
       ego_pages_v epv,
       fnd_objects fo
       where
       PPC.PROJECT_ID = l_project_id
       AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
       AND PPC.CLASS_CODE = PCC.CLASS_CODE
       AND fo.obj_name = 'PA_PROJECTS'
       and epv.object_id = fo.object_id and epv.object_name = 'PA_PROJECTS'
       and 'CLASS_CODE:' || PCC.CLASS_CODE_ID  = epv.classification_code
       and epv.data_level_int_name = 'TASK_LEVEL'
       AND epv.page_id = p_page_id;

Line: 190

     SELECT
       epv.page_id
       FROM  PA_TASK_TYPES TT,
       PA_LOOKUPS pl,
       ego_pages_v epv,
       fnd_objects fo
       WHERE
        PL.LOOKUP_TYPE     = 'PA_EXT_DRIVER_TYPE'
       AND PL.LOOKUP_CODE = 'TASK_TYPE'
       AND tt.task_type_id =
       (
	select type_id from pa_proj_elements
	where proj_element_id =  p_object_id
	AND object_type = 'PA_TASKS'
	)
       AND fo.obj_name = 'PA_PROJECTS'
       and epv.object_id = fo.object_id and epv.object_name = 'PA_PROJECTS'
       and 'TASK_TYPE:' || TT.TASK_TYPE_ID = epv.classification_code
       and epv.data_level_int_name = 'TASK_LEVEL'
       AND epv.page_id = p_page_id;