73: FROM fnd_application
74: WHERE application_short_name = 'SQLGL';
75:
76: -- Get concatenated segment delimiter
77: delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',cht_id);
78:
79: -- Concatened alias
80: IF alias IS NULL THEN
81: addition1 := NULL;
149: FROM fnd_application
150: WHERE application_short_name = 'SQLGL';
151:
152: -- Get concatenated segment delimiter
153: delimiter := fnd_flex_ext.get_delimiter('SQLGL','GL#',cht_id);
154:
155: -- Concatened alias
156: IF alias IS NULL THEN
157: addition := NULL;
159: addition := alias || '.';
160: END IF;
161:
162: -- Break concatenated segments
163: -- nsegs := fnd_flex_ext.breakup_segments(catseg1, delimiter, seg1);
164: -- nsegs := fnd_flex_ext.breakup_segments(catseg2, delimiter, seg2);
165: nsegs := breakup_segments(catseg1, delimiter, seg1);
166: nsegs := breakup_segments(catseg2, delimiter, seg2);
167:
160: END IF;
161:
162: -- Break concatenated segments
163: -- nsegs := fnd_flex_ext.breakup_segments(catseg1, delimiter, seg1);
164: -- nsegs := fnd_flex_ext.breakup_segments(catseg2, delimiter, seg2);
165: nsegs := breakup_segments(catseg1, delimiter, seg1);
166: nsegs := breakup_segments(catseg2, delimiter, seg2);
167:
168: -- Assemble where Clause