APPS.GL_BIS_ALERTS_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 167: ', fnd_id_flex_segments sg1 ';

163:
164: IF (p_dim1_level_code = 0) THEN
165: trg_select := trg_select ||
166: ', bis_flex_mappings_v fm1 ' ||
167: ', fnd_id_flex_segments sg1 ';
168: END IF;
169:
170: IF (p_dim2_level_code = 0) THEN
171: trg_select := trg_select ||

Line 173: ', fnd_id_flex_segments sg2 ';

169:
170: IF (p_dim2_level_code = 0) THEN
171: trg_select := trg_select ||
172: ', bis_flex_mappings_v fm2 ' ||
173: ', fnd_id_flex_segments sg2 ';
174: END IF;
175:
176: trg_select := trg_select ||
177: 'WHERE tl.target_level_id = :target_level_id ' ||

Line 900: fnd_id_flex_segments sg

896: FROM bisbv_target_levels tl,
897: bisbv_dimension_levels dl,
898: gl_sets_of_books sob,
899: bis_flex_mappings_v fm,
900: fnd_id_flex_segments sg
901: WHERE tl.target_level_id = p_target_rec.target_level_id
902: AND dl.dimension_level_id = tl.dimension1_level_id
903: AND dl.dimension_level_short_name <> c_t_gl_companys
904: AND fm.level_id = tl.dimension1_level_id

Line 920: fnd_id_flex_segments sg

916: FROM bisbv_target_levels tl,
917: bisbv_dimension_levels dl,
918: gl_sets_of_books sob,
919: bis_flex_mappings_v fm,
920: fnd_id_flex_segments sg
921: WHERE tl.target_level_id = p_target_rec.target_level_id
922: AND dl.dimension_level_id = tl.dimension1_level_id
923: AND dl.dimension_level_short_name <> c_t_gl_sms
924: AND fm.level_id = tl.dimension2_level_id