APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_QUESTIONNAIRE_ITEMS

Line 311: FROM iex_questionnaire_items;

307: OR (disposition_code is NULL));
308:
309: CURSOR pre_del_strategy IS
310: SELECT predel_strategy_enabled
311: FROM iex_questionnaire_items;
312:
313: l_pre_del_strategy VARCHAR2(1);
314: l_unpro_dels number;
315:

Line 2446: from iex_questionnaire_items;

2442:
2443: -- Start for
2444: cursor c_collections_method is
2445: select collections_methods
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

Line 2592: -- select collections_methods into from iex_questionnaire_items;

2588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id : '|| l_org_id);
2589: OPEN c_collections_method;
2590: FETCH c_collections_method INTO l_collection_method;
2591: close c_collections_method;
2592: -- select collections_methods into from iex_questionnaire_items;
2593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collection_method);
2594: OPEN C_org_id_coll_method (l_org_id);
2595: FETCH C_org_id_coll_method INTO l_org_id_coll_method;
2596: if l_collection_method = 'DUN_STR' and C_org_id_coll_method%NOTFOUND THEN

Line 3389: from iex_questionnaire_items;

3385: using_billto_level,
3386: using_delinquency_level,
3387: define_party_running_level,
3388: define_ou_running_level
3389: from iex_questionnaire_items;
3390:
3391: cursor c_system_str_level
3392: is
3393: SELECT iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',preference_value)

Line 3401: from iex_questionnaire_items;

3397: AND org_id IS NULL;
3398:
3399: cursor c_collections_method is
3400: select collections_methods
3401: from iex_questionnaire_items;
3402:
3403:
3404: begin
3405: writelog('Begin gen_xml_header_data_strategy');

Line 3974: from iex_questionnaire_items;

3970: l_api_name varchar2(100) := 'gen_xml_append_closetag_sty';
3971:
3972: cursor c_collections_method is
3973: select collections_methods
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

Line 4103: -- select collections_methods into l_collection_method from iex_questionnaire_items;

4099: --l_org_id := format_string(l_org_id);
4100: OPEN c_collections_method;
4101: FETCH c_collections_method INTO l_collection_method;
4102: close c_collections_method;
4103: -- select collections_methods into l_collection_method from iex_questionnaire_items;
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collection_method);
4105:
4106: OPEN C_ORG_ID_COLL_METHOD (l_org_id);
4107: FETCH C_ORG_ID_COLL_METHOD INTO l_org_id_coll_method;

Line 4259: from IEX_QUESTIONNAIRE_ITEMS;

4255: begin
4256:
4257: select DEFINE_PARTY_RUNNING_LEVEL,DEFINE_OU_RUNNING_LEVEL
4258: into l_party_override,l_org_override
4259: from IEX_QUESTIONNAIRE_ITEMS;
4260:
4261: write_log(FND_LOG.LEVEL_STATEMENT, 'Party Level Strategy Override and Operating Unit Level Override values ' || l_party_override || ' , ' || l_org_override);
4262:
4263: EXCEPTION