APPS.HR_MISC_WEB dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 201: from FND_DESCR_FLEX_COLUMN_USAGES

197: user_column_name VARCHAR2
198: )
199: IS
200: select application_column_name
201: from FND_DESCR_FLEX_COLUMN_USAGES
202: where descriptive_flex_context_code = 'SSHR Information'
203: and end_user_column_name = user_column_name
204: -- ***** Start new code for bug 2731002 *****
205: and application_id=800

Line 209: col_name fnd_descr_flex_column_usages.application_column_name%TYPE DEFAULT NULL;

205: and application_id=800
206: and descriptive_flexfield_name='Org Developer DF';
207: -- ***** End new code for bug 2731002 *****
208:
209: col_name fnd_descr_flex_column_usages.application_column_name%TYPE DEFAULT NULL;
210: v_BlockStr VARCHAR2(500);
211: v_ColName VARCHAR2(100);
212: v_BusGrpID NUMBER;
213: v_segment_value VARCHAR2(200) DEFAULT NULL;