APPS.GMF_FND_SEGMENT_INFO dependencies on FND_ID_FLEX_SEGMENTS

Line 8: FROM fnd_id_flex_segments fnd,gl_sets_of_books gls

4: enddate date,
5: segmentname varchar2,
6: sobname varchar2) IS
7: SELECT fnd.segment_name, fnd.segment_num
8: FROM fnd_id_flex_segments fnd,gl_sets_of_books gls
9: WHERE gls.name=sobname AND
10: gls.chart_of_accounts_id=fnd.id_flex_num AND
11: fnd.segment_name=nvl(segmentname,fnd.segment_name) AND
12: fnd.creation_date BETWEEN

Line 25: FROM fnd_id_flex_segments fnd,

21: Begin
22: IF ((segmentname IS NOT NULL) AND (NOT segment_info%ISOPEN)) THEN
23: SELECT fnd.segment_num
24: INTO segmentnum
25: FROM fnd_id_flex_segments fnd,
26: gl_sets_of_books gls
27: WHERE gls.name=sobname
28: AND gls.chart_of_accounts_id=fnd.id_flex_num
29: AND fnd.segment_name=segmentname;