DBA Data[Home] [Help]

APPS.XLA_FLEX_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 179: FROM fnd_id_flex_segments_vl

175:
176: CURSOR c_segment_name
177: IS
178: SELECT segment_name
179: FROM fnd_id_flex_segments_vl
180: WHERE application_id = p_application_id
181: AND id_flex_code = p_flex_code
182: AND id_flex_num = p_chart_of_accounts_id
183: AND application_column_name = p_flexfield_segment_code

Line 416: FROM fnd_id_flex_segments_vl

412: CURSOR c_segment_info
413: IS
414: SELECT segment_name
415: ,segment_num
416: FROM fnd_id_flex_segments_vl
417: WHERE application_id = p_application_id
418: AND id_flex_code = p_flex_code
419: AND id_flex_num = p_chart_of_accounts_id
420: AND application_column_name = p_flexfield_segment_code

Line 428: FROM fnd_id_flex_segments

424:
425: CURSOR c_segment_num
426: IS
427: SELECT count(segment_num)
428: FROM fnd_id_flex_segments
429: WHERE application_id = p_application_id
430: AND id_flex_code = p_flex_code
431: AND id_flex_num = p_chart_of_accounts_id
432: AND enabled_flag = 'Y'

Line 961: FROM fnd_id_flex_segments

957:
958: CURSOR c_valueset
959: IS
960: SELECT flex_value_set_id
961: FROM fnd_id_flex_segments
962: WHERE application_id = p_application_id
963: AND id_flex_code = p_id_flex_code
964: AND id_flex_num = p_id_flex_num
965: AND application_column_name = p_segment_code