DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_QUESTIONNAIRE_ITEMS

Line 1448: from iex_questionnaire_items;

1444: p_collections_methods varchar2(20);
1445:
1446: cursor c_promise_str is
1447: select promise_enabled, collections_methods
1448: from iex_questionnaire_items;
1449:
1450: BEGIN
1451:
1452: open c_promise_str;

Line 1749: from iex_questionnaire_items;

1745:
1746: cursor c_questionnaire_details is
1747: select business_level, using_customer_level, using_account_level, using_billto_level,
1748: using_delinquency_level, define_ou_running_level , define_party_running_level
1749: from iex_questionnaire_items;
1750:
1751: l_business_level varchar2(20);
1752: l_using_customer_level varchar2(1);
1753: l_using_account_level varchar2(1);

Line 1773: c_str_upd := 'update iex_questionnaire_items set ';

1769: l_using_delinquency_level,l_define_ou_running_level,l_define_party_running_level;
1770: close c_questionnaire_details;
1771: iex_debug_pub.logmessage(' In procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP Begin updating multi level strategy set up in questionnaire table');
1772:
1773: c_str_upd := 'update iex_questionnaire_items set ';
1774: l_count := 0;
1775:
1776: IF l_using_customer_level is null then
1777: