APPS.FII_FA_CAT_C dependencies on FND_ID_FLEX_SEGMENTS

Line 194: FROM fnd_id_flex_segments seg,

190: l_major_seg,
191: l_major_flex_value_set_id,
192: l_major_val_type_code,
193: l_parent_value_set_id
194: FROM fnd_id_flex_segments seg,
195: FND_SEGMENT_ATTRIBUTE_VALUES fsav,
196: FA_SYSTEM_CONTROLS sys,
197: fnd_flex_value_sets fv
198: WHERE fsav.application_id = 140

Line 273: FROM fnd_id_flex_segments seg,

269: INTO l_minor_seg,
270: l_minor_flex_value_set_id,
271: l_minor_val_type_code,
272: l_parent_value_set_id
273: FROM fnd_id_flex_segments seg,
274: FND_SEGMENT_ATTRIBUTE_VALUES fsav,
275: FA_SYSTEM_CONTROLS sys,
276: fnd_flex_value_sets fv
277: WHERE fsav.application_id = 140

Line 557: ' FROM fnd_id_flex_segments seg1,

553: ' || g_fii_user_id || ',
554: ' || g_fii_login_id || ' , '; -- completed below
555:
556: l_from_stmt :=
557: ' FROM fnd_id_flex_segments seg1,
558: FA_CATEGORIES_B cat,
559: FA_SYSTEM_CONTROLS sys, '; -- completed below
560:
561: l_where_stmt :=

Line 613: ', fnd_id_flex_segments seg2 ';

609: l_sel_stmt := l_sel_stmt || ' NULL, NULL ';
610: else
611:
612: l_from_stmt := l_from_stmt ||
613: ', fnd_id_flex_segments seg2 ';
614:
615: l_where_stmt := l_where_stmt ||
616: ' AND seg2.application_id = 140
617: AND seg2.id_flex_code = ''CAT#''