APPS.PER_RI_RT_UTIL_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 107: FROM fnd_descr_flex_col_usage_vl

103: p_column VARCHAR2) return VARCHAR2
104: IS
105: CURSOR get_window_prompt IS
106: SELECT form_left_prompt
107: FROM fnd_descr_flex_col_usage_vl
108: WHERE descriptive_flexfield_name = p_flexfield
109: AND descriptive_flex_context_code = p_context
110: AND application_column_name = p_column;
111: l_end_user_column_name VARCHAR2(100);

Line 126: FROM fnd_descr_flex_col_usage_vl

122: p_value VARCHAR2) return varchar2
123: IS
124: Cursor get_sel_set IS
125: SELECT nvl(flex_value_set_id,-999)
126: FROM fnd_descr_flex_col_usage_vl
127: WHERE descriptive_flexfield_name = p_flexfield
128: AND descriptive_flex_context_code = p_context
129: AND application_column_name = p_column;
130:

Line 133: FROM fnd_descr_flex_col_usage_vl

129: AND application_column_name = p_column;
130:
131: CURSOR chk_segment_enabled IS
132: SELECT 1
133: FROM fnd_descr_flex_col_usage_vl
134: WHERE descriptive_flexfield_name = p_flexfield
135: AND descriptive_flex_context_code = p_context
136: AND application_column_name = p_column
137: AND display_flag = 'Y'

Line 216: FROM fnd_descr_flex_col_usage_vl

212: p_context VARCHAR2) RETURN NUMBER
213: IS
214: CURSOR chk_segments_for_context IS
215: SELECT count(*)
216: FROM fnd_descr_flex_col_usage_vl
217: WHERE descriptive_flexfield_name = p_flexfield
218: AND descriptive_flex_context_code = p_context;
219: l_number NUMBER;
220: BEGIN