APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on IEX_LOOKUPS_V

Line 460: from iex_lookups_v

456: --begin bug#6717849 schekuri 31-Jul-2009
457: l_level_count number;
458: cursor c_multi_level
459: is select lookup_code
460: from iex_lookups_v
461: where lookup_type='IEX_RUNNING_LEVEL'
462: and lookup_code= 'CUSTOMER'
463: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
464: --end bug#6717849 schekuri 31-Jul-2009

Line 566: from iex_lookups_v

562:
563: --begin bug#6717849 schekuri 31-Jul-2009
564: select count(1)
565: into l_level_count
566: from iex_lookups_v
567: where lookup_type='IEX_RUNNING_LEVEL'
568: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
569:
570: if l_level_count>1 then

Line 821: from iex_lookups_v

817: --begin bug#6717849 schekuri 31-Jul-2009
818: l_level_count number;
819: cursor c_multi_level
820: is select lookup_code
821: from iex_lookups_v
822: where lookup_type='IEX_RUNNING_LEVEL'
823: and lookup_code= 'ACCOUNT'
824: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
825: --end bug#6717849 schekuri 31-Jul-2009

Line 943: from iex_lookups_v

939:
940: --begin bug#6717849 schekuri 31-Jul-2009
941: select count(1)
942: into l_level_count
943: from iex_lookups_v
944: where lookup_type='IEX_RUNNING_LEVEL'
945: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
946:
947: if l_level_count>1 then

Line 1216: from iex_lookups_v

1212: --begin bug#6717849 schekuri 31-Jul-2009
1213: l_level_count number;
1214: cursor c_multi_level
1215: is select lookup_code
1216: from iex_lookups_v
1217: where lookup_type='IEX_RUNNING_LEVEL'
1218: and lookup_code= 'BILL_TO'
1219: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1220: --end bug#6717849 schekuri 31-Jul-2009

Line 1334: from iex_lookups_v

1330:
1331: --begin bug#6717849 schekuri 31-Jul-2009
1332: select count(1)
1333: into l_level_count
1334: from iex_lookups_v
1335: where lookup_type='IEX_RUNNING_LEVEL'
1336: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1337:
1338: if l_level_count>1 then