DBA Data[Home] [Help]

APPS.HR_ID_FLEX_STRUCTURE_INFO dependencies on FND_ID_FLEX_SEGMENTS

Line 164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE

160: --
161: -- Local cursors
162: --
163: CURSOR csr_id_flex_segments
164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE
165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE
166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE
167: )
168: IS

Line 165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE

161: -- Local cursors
162: --
163: CURSOR csr_id_flex_segments
164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE
165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE
166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE
167: )
168: IS
169: SELECT ifs.application_column_name

Line 166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE

162: --
163: CURSOR csr_id_flex_segments
164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE
165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE
166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE
167: )
168: IS
169: SELECT ifs.application_column_name
170: ,ifs.segment_num

Line 183: FROM fnd_id_flex_segments_vl ifs

179: ,ifs.form_left_prompt
180: ,ifs.maximum_description_len
181: ,ifs.required_flag
182: ,ifs.segment_name
183: FROM fnd_id_flex_segments_vl ifs
184: ,fnd_id_flex_structures fst
185: WHERE ifs.application_id = fst.application_id
186: AND ifs.id_flex_code = fst.id_flex_code
187: AND ifs.id_flex_num = fst.id_flex_num