APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on IEX_LOOKUPS_V

Line 653: from iex_lookups_v

649: --begin bug#6717849 schekuri 31-Jul-2009
650: l_level_count number;
651: cursor c_multi_level
652: is select lookup_code
653: from iex_lookups_v
654: where lookup_type='IEX_RUNNING_LEVEL'
655: and lookup_code= 'CUSTOMER'
656: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
657: --end bug#6717849 schekuri 31-Jul-2009

Line 706: from iex_lookups_v

702:
703: --begin bug#6717849 schekuri 31-Jul-2009
704: select count(1)
705: into l_level_count
706: from iex_lookups_v
707: where lookup_type='IEX_RUNNING_LEVEL'
708: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
709:
710: if l_level_count>1 then

Line 1215: from iex_lookups_v

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

Line 1249: from iex_lookups_v

1245:
1246: --begin bug#6717849 schekuri 31-Jul-2009
1247: select count(1)
1248: into l_level_count
1249: from iex_lookups_v
1250: where lookup_type='IEX_RUNNING_LEVEL'
1251: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1252:
1253: if l_level_count>1 then

Line 1894: from iex_lookups_v

1890: --begin bug#6717849 schekuri 31-Jul-2009
1891: l_level_count number;
1892: cursor c_multi_level
1893: is select lookup_code
1894: from iex_lookups_v
1895: where lookup_type='IEX_RUNNING_LEVEL'
1896: and lookup_code= 'BILL_TO'
1897: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1898: --end bug#6717849 schekuri 31-Jul-2009

Line 1930: from iex_lookups_v

1926:
1927: --begin bug#6717849 schekuri 31-Jul-2009
1928: select count(1)
1929: into l_level_count
1930: from iex_lookups_v
1931: where lookup_type='IEX_RUNNING_LEVEL'
1932: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1933:
1934: if l_level_count>1 then