APPS.PJI_PAGE_LAYOUTS SQL Statements

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

Line: 12

			SELECT 	page_id
			FROM  	pa_page_layouts play,
					pa_projects_all proj,
					pa_project_types_all ptype
			WHERE 1=1
			AND proj.PROJECT_ID =p_project_id
			AND play.PAGE_TYPE_CODE =p_page_type_code
			AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE
			AND play.PERS_FUNCTION_NAME = 'PJI_REP_PP_' || ptype.PROJECT_TYPE_CLASS_CODE
			AND proj.ORG_ID = ptype.ORG_ID
			AND play.page_id < 1000;

Line: 52

			SELECT 	page_name
			FROM  	pa_page_layouts play,
					pa_projects_all proj,
					pa_project_types_all ptype
			WHERE 1=1
			AND proj.PROJECT_ID =p_project_id
			AND play.PAGE_TYPE_CODE =p_page_type_code
			AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE
			AND play.PERS_FUNCTION_NAME = 'PJI_REP_PP_' || ptype.PROJECT_TYPE_CLASS_CODE
			AND proj.ORG_ID = ptype.ORG_ID
			AND play.page_id < 1000;