APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on DUAL

Line 177: from dual;

173: --Start for bug 10054672 gnramasa 27th Aug 10
174: /*
175: select NVL(FND_PROFILE.value('IEX_LEASE_ENABLED'), 'N')
176: into l_ctr_enbl_flg
177: from dual;
178:
179: if l_ctr_enbl_flg='N' then
180: l_where :=l_where||' and ipd1.contract_id is null';
181: else

Line 192: from dual;

188: --End for bug 10054672 gnramasa 27th Aug 10
189:
190: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')
191: into l_coll_rate
192: from dual;
193:
194: if l_coll_rate is null then
195: l_coll_rate:='Corporate';
196: end if;

Line 462: from dual;

458: END IF;
459:
460: select TRUNC(sysdate)
461: into l_sysdate
462: from dual;
463:
464: l_new_line := '
465: ';
466: FND_FILE.put_line( FND_FILE.LOG,'10') ;

Line 562: from dual;

558:
559:
560: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')
561: into l_coll_rate
562: from dual;
563:
564: /*if l_coll_rate is null then
565: select default_exchange_rate_type
566: into l_coll_rate

Line 578: from dual;

574: --Start for bug 10054672 gnramasa 27th Aug 10
575: /*
576: select NVL(FND_PROFILE.value('IEX_LEASE_ENABLED'), 'N')
577: into l_ctr_enbl_flg
578: from dual;
579:
580: if l_ctr_enbl_flg='N' then
581: FND_FILE.put_line( FND_FILE.LOG,'20') ;
582: