DBA Data[Home] [Help]

APPS.XLA_FLEX_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 178: FROM fnd_id_flex_segments_vl

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

Line 410: FROM fnd_id_flex_segments_vl

406: CURSOR c_segment_info
407: IS
408: SELECT segment_name
409: ,segment_num
410: FROM fnd_id_flex_segments_vl
411: WHERE application_id = p_application_id
412: AND id_flex_code = p_flex_code
413: AND id_flex_num = p_chart_of_accounts_id
414: AND application_column_name = p_flexfield_segment_code

Line 422: FROM fnd_id_flex_segments

418:
419: CURSOR c_segment_num
420: IS
421: SELECT count(segment_num)
422: FROM fnd_id_flex_segments
423: WHERE application_id = p_application_id
424: AND id_flex_code = p_flex_code
425: AND id_flex_num = p_chart_of_accounts_id
426: AND enabled_flag = 'Y'

Line 892: FROM fnd_id_flex_segments

888:
889: CURSOR c_valueset
890: IS
891: SELECT flex_value_set_id
892: FROM fnd_id_flex_segments
893: WHERE application_id = p_application_id
894: AND id_flex_code = p_id_flex_code
895: AND id_flex_num = p_id_flex_num
896: AND application_column_name = p_segment_code