APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_APP_PREFERENCES_B

Line 2428: from iex_app_preferences_b

2424: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
2425:
2426: CURSOR c_system_str_level(p_org_id number) IS
2427: select preference_value
2428: from iex_app_preferences_b
2429: where preference_name='COLLECTIONS STRATEGY LEVEL'
2430: and enabled_flag='Y'
2431: and (org_id = p_org_id or org_id is null)
2432: order by nvl(org_id,0) desc;

Line 2436: from iex_app_preferences_b

2432: order by nvl(org_id,0) desc;
2433:
2434: CURSOR c_system_strategy_level IS
2435: select preference_value
2436: from iex_app_preferences_b
2437: where preference_name='COLLECTIONS STRATEGY LEVEL'
2438: and enabled_flag='Y'
2439: and org_id is null;
2440:

Line 2450: from IEX_app_preferences_b where

2446: from iex_questionnaire_items;
2447:
2448: cursor c_org_id_coll_method(p_org_id number) is
2449: select nvl(collections_method,'STRATEGIES')
2450: from IEX_app_preferences_b where
2451: org_id = p_org_id and enabled_flag ='Y';
2452:
2453: CURSOR c_check_ou_methods (p_org_id number) IS
2454: SELECT COUNT(1)

Line 2455: from hr_operating_units a, IEX_app_preferences_b b

2451: org_id = p_org_id and enabled_flag ='Y';
2452:
2453: CURSOR c_check_ou_methods (p_org_id number) IS
2454: SELECT COUNT(1)
2455: from hr_operating_units a, IEX_app_preferences_b b
2456: where mo_global.check_access(a.organization_id) = 'Y'
2457: and a.organization_id = b.org_id
2458: and b.collections_method = 'STRATEGIES'
2459: and b.enabled_flag ='Y'

Line 2601: -- select nvl(collections_method,'STRATEGIES') into l_org_id_coll_method from IEX_app_preferences_b where org_id = l_org_id and enabled_flag ='Y';

2597: l_unregistered_org_ids := l_unregistered_org_ids +1;
2598: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' is not registered');
2599: END IF;
2600: close C_org_id_coll_method;
2601: -- select nvl(collections_method,'STRATEGIES') into l_org_id_coll_method from IEX_app_preferences_b where org_id = l_org_id and enabled_flag ='Y';
2602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);
2603:
2604: if l_org_id_coll_method is not null and l_collection_method = 'DUN_STR' and l_org_id_coll_method <> 'STRATEGIES' then
2605: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' setup for ' || l_org_id_coll_method);

Line 2717: from iex_app_preferences_b

2713: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override and Party Level override are off');
2714:
2715: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value
2716: into l_DefaultStrategyLevel,l_StrategyLevelName
2717: from iex_app_preferences_b
2718: where preference_name='COLLECTIONS STRATEGY LEVEL'
2719: and enabled_flag='Y'
2720: and org_id is null;
2721:

Line 2840: from iex_app_preferences_b

2836: fnd_file.put_line(FND_FILE.LOG, 'Party Level override is off');
2837:
2838: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value
2839: into l_DefaultStrategyLevel,l_StrategyLevelName
2840: from iex_app_preferences_b
2841: where preference_name='COLLECTIONS STRATEGY LEVEL'
2842: and enabled_flag='Y'
2843: and org_id is null;
2844:

Line 3394: FROM iex_app_preferences_b

3390:
3391: cursor c_system_str_level
3392: is
3393: SELECT iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',preference_value)
3394: FROM iex_app_preferences_b
3395: WHERE preference_name='COLLECTIONS STRATEGY LEVEL'
3396: AND enabled_flag = 'Y'
3397: AND org_id IS NULL;
3398:

Line 3978: from IEX_app_preferences_b where

3974: from iex_questionnaire_items;
3975:
3976: cursor c_org_id_coll_method(p_org_id number) is
3977: select nvl(collections_method,'STRATEGIES')
3978: from IEX_app_preferences_b where
3979: org_id = p_org_id and enabled_flag ='Y';
3980:
3981:
3982: