APPS.HR_UTIL_FLEX_WEB dependencies on FND_ID_FLEX_SEGMENTS

Line 108: -- by comparing with the application_column_name in fnd_id_flex_segments

104: -- We allow users to enter either "user segment name, such as: Job Code, Job
105: -- Title" or physical segment column name, such as SEGMENT1 ... SEGMENT30.
106: -- 3) Once segment name is returned, check whether the segment name starts with
107: -- 'SEGMENT%'. If it does, then we will validate the physical segment name
108: -- by comparing with the application_column_name in fnd_id_flex_segments
109: -- table for the structure and flex_code. If the segment names are equal,
110: -- then the segment name entered is valid for the structure, stop here.
111: -- Otherwise, raise an error.
112: --

Line 377: from fnd_id_flex_segments

373: l_app_id number default null;
374:
375: cursor csr_chk_flex_app_col_name is
376: select APPLICATION_COLUMN_NAME
377: from fnd_id_flex_segments
378: where APPLICATION_ID = l_app_id
379: and ID_FLEX_CODE = p_flex_code
380: and ID_FLEX_NUM = p_id_flex_num;
381: --