APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_APP_PREFERENCES_B

Line 400: FROM IEX_APP_PREFERENCES_B

396:
397: --Begin Bug 8942646 12-Oct-2009 barathsr
398: CURSOR c_get_level IS
399: SELECT PREFERENCE_VALUE
400: FROM IEX_APP_PREFERENCES_B
401: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
402: and enabled_flag='Y'
403: and org_id is null;
404:

Line 413: FROM IEX_APP_PREFERENCES_B

409: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
410:
411: cursor c_get_ou_biz_lvl(c_org_id number) is
412: SELECT PREFERENCE_VALUE
413: FROM IEX_APP_PREFERENCES_B
414: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
415: and (org_id=c_org_id or org_id is null)
416: and enabled_flag='Y'
417: order by nvl(org_id,0) desc ;

Line 728: FROM IEX_APP_PREFERENCES_B

724:
725:
726: CURSOR c_get_level IS
727: SELECT PREFERENCE_VALUE
728: FROM IEX_APP_PREFERENCES_B
729: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
730: and enabled_flag='Y'
731: and org_id is null;
732:

Line 741: FROM IEX_APP_PREFERENCES_B

737: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
738:
739: cursor c_get_ou_biz_lvl(c_org_id number) is
740: SELECT PREFERENCE_VALUE
741: FROM IEX_APP_PREFERENCES_B
742: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
743: and (org_id=c_org_id or org_id is null)
744: and enabled_flag='Y'
745: order by nvl(org_id,0) desc ;

Line 13510: FROM IEX_APP_PREFERENCES_B

13506: l_allowed_level varchar2(20);
13507:
13508: CURSOR c_get_level(c_org_id number) IS
13509: SELECT PREFERENCE_VALUE
13510: FROM IEX_APP_PREFERENCES_B
13511: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
13512: and (org_id=c_org_id or org_id is null)
13513: and enabled_flag='Y'
13514: order by nvl(org_id,0) desc ;