148:
149:
150: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')
151: into l_coll_rate
152: from dual;
153:
154: /* if l_coll_rate is null then
155: select default_exchange_rate_type
156: into l_coll_rate
332: END IF;
333:
334: select TRUNC(sysdate)
335: into l_sysdate
336: from dual;
337:
338: if p_collector is null then
339: l_collector:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
340: end if;