APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on IEX_APP_PREFERENCES_B

Line 152: from iex_app_preferences_b

148:
149: --Begin Bug #6311505 bibeura 23-Oct-2007
150: select preference_value
151: into l_strategy_level
152: from iex_app_preferences_b
153: where preference_name='COLLECTIONS STRATEGY LEVEL'
154: and org_id is null
155: and enabled_flag='Y';
156: -- Start for bug 8708271 PNAVEENK

Line 291: l_security_where := l_security_where || ' and exists (select 1 from iex_app_preferences_b pref where pref.preference_name=''COLLECTIONS STRATEGY LEVEL'' '

287: ||' and hzprf.preference_code = ''PARTY_ID'' and hzprf.party_id= iex_delinquencies_uwq_v.customer_id) ';
288: end if;
289: else
290: if l_org_override = 'Y' then
291: l_security_where := l_security_where || ' and exists (select 1 from iex_app_preferences_b pref where pref.preference_name=''COLLECTIONS STRATEGY LEVEL'' '
292: ||' and pref.preference_value=''DELINQUENCY'' and pref.org_id = iex_delinquencies_uwq_v.org_id) ';
293: end if;
294: end if;
295: end if; -- added if statement by a bug 16494272

Line 332: l_security_where := l_security_where || ' and exists (select 1 from iex_app_preferences_b pref where pref.preference_name=''COLLECTIONS STRATEGY LEVEL'' '

328: ||' and hzprf.preference_code = ''PARTY_ID'' and hzprf.party_id = iex_delinquencies_uwq_v.customer_id) ';
329: end if;
330: else
331: if l_org_override = 'Y' then
332: l_security_where := l_security_where || ' and exists (select 1 from iex_app_preferences_b pref where pref.preference_name=''COLLECTIONS STRATEGY LEVEL'' '
333: ||' and pref.preference_value=''DELINQUENCY'' and pref.org_id=iex_delinquencies_uwq_v.org_id) ';
334: end if;
335: end if;
336: -- end for bug 8708271

Line 490: l_security_where := l_security_where || ' and exists (select 1 from iex_app_preferences_b pref where pref.preference_name=''COLLECTIONS STRATEGY LEVEL'' '

486: ||' and hzprf.preference_code = ''PARTY_ID'' and hzprf.party_id = iex_delinquencies_uwq_v.customer_id) ';
487: end if;
488: else
489: if l_org_override = 'Y' then
490: l_security_where := l_security_where || ' and exists (select 1 from iex_app_preferences_b pref where pref.preference_name=''COLLECTIONS STRATEGY LEVEL'' '
491: ||' and pref.preference_value=''DELINQUENCY'' and pref.org_id=iex_delinquencies_uwq_v.org_id) ';
492: end if;
493: end if;
494: end if; -- added if statement by a bug 16494272

Line 640: FROM IEX_APP_PREFERENCES_B

636: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
637:
638: CURSOR c_strategy_level IS
639: SELECT PREFERENCE_VALUE
640: FROM IEX_APP_PREFERENCES_B
641: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
642: and org_id is null
643: and enabled_flag='Y';
644:

Line 1203: FROM IEX_APP_PREFERENCES_B

1199: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1200:
1201: CURSOR c_strategy_level IS
1202: SELECT PREFERENCE_VALUE
1203: FROM IEX_APP_PREFERENCES_B
1204: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
1205: and org_id is null
1206: and enabled_flag='Y'; --bug#6717849 schekuri 31-Jul-2009
1207:

Line 1882: FROM IEX_APP_PREFERENCES_B

1878: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1879:
1880: CURSOR c_strategy_level IS
1881: SELECT PREFERENCE_VALUE
1882: FROM IEX_APP_PREFERENCES_B
1883: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
1884: and org_id is null
1885: and enabled_flag='Y';
1886: