APPS.FND_IREP_CP_PKG SQL Statements

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

Line: 21

	  select
	  FDFCU.END_USER_COLUMN_NAME,
	  FDFCU.REQUIRED_FLAG,
          DECODE(FDFCU.DISPLAY_FLAG, 'N', 'N', 'Y'),
	  TL.DESCRIPTION,
	  TL.FORM_LEFT_PROMPT,
	  FVS.FLEX_VALUE_SET_NAME
	  from
	  FND_CONCURRENT_PROGRAMS FCP,
	  FND_DESCR_FLEX_COLUMN_USAGES FDFCU,
	  FND_DESCR_FLEX_COL_USAGE_TL TL,
	  FND_FLEX_VALUE_SETS FVS
	  where
	  FCP.APPLICATION_ID=p_app_id AND
	  FCP.CONCURRENT_PROGRAM_ID=p_cp_id AND
	  FDFCU.ENABLED_FLAG='Y' AND
	  FDFCU.DESCRIPTIVE_FLEXFIELD_NAME=
		'$SRS$.'||FCP.CONCURRENT_PROGRAM_NAME AND
	  TL.DESCRIPTIVE_FLEXFIELD_NAME=FDFCU.DESCRIPTIVE_FLEXFIELD_NAME AND
	  TL.APPLICATION_COLUMN_NAME=FDFCU.APPLICATION_COLUMN_NAME AND
	  TL.LANGUAGE='US' AND
	  FDFCU.FLEX_VALUE_SET_ID=FVS.FLEX_VALUE_SET_ID AND
          FDFCU.APPLICATION_ID = FCP.APPLICATION_ID AND
          TL.APPLICATION_ID = FDFCU.APPLICATION_ID AND
          TL.DESCRIPTIVE_FLEX_CONTEXT_CODE=FDFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE
	  order by
	  FDFCU.COLUMN_SEQ_NUM;