DBA Data[Home] [Help]

APPS.IEX_SEND_XML_PVT dependencies on XDO_LOBS

Line 77: from xdo_lobs

73: WriteLog(l_msg || 'l_iso_lang = '||l_iso_lang );
74:
75: select count(distinct territory)
76: into l_no_terr
77: from xdo_lobs
78: where application_short_name='IEX' and upper(language)=l_iso_lang
79: and territory <> '00'
80: and lob_code = l_templ_code;
81:

Line 90: from xdo_lobs

86: --if no of territory is >1 then send territory as '00' else the default territory for that template.
87: if l_no_terr = 1 then
88: select distinct territory
89: into l_templ_terr
90: from xdo_lobs
91: where application_short_name='IEX' and upper(language)=l_iso_lang
92: and territory <> '00'
93: and lob_code = l_templ_code;
94: