APPS.IEX_STRATEGY_WORK_PUB dependencies on IEX_STRATEGIES

Line 110: select org_id from iex_strategies where strategy_id = p_strategy_id;

106: l_contact_party_id number; -- bug 3955222
107:
108: --Added for Bug 10401991 20-Jan-2011 barathsr
109: cursor c_get_org_id ( p_strategy_id number) is
110: select org_id from iex_strategies where strategy_id = p_strategy_id;
111:
112: v_org_id number; --Added for Bug 10401991 20-Jan-2011 barathsr
113: l_turnoff_coll_on_bankru varchar2(10);
114: l_no_of_bankruptcy number;

Line 476: from iex_strategies

472: , p_org_id => v_org_id)
473: = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr*/
474: select decode(strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT', 30, 'BILL_TO', 40, 'DELINQUENCY', 'DELINQUENCY')
475: into l_DefaultStrategyLevel
476: from iex_strategies
477: where strategy_id = l_strategy_id;
478:
479: l_dun_yn := iex_utilities.DunningMinAmountCheck(
480: p_cust_account_id => l_cust_account_id

Line 633: from iex_strategies

629: -- set dunning_object_id and dunnint_level
630: begin
631: select decode(strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT', 30, 'BILL_TO', 40, 'DELINQUENCY', 'DELINQUENCY')
632: into l_DefaultStrategyLevel
633: from iex_strategies
634: where strategy_id = l_strategy_id;
635:
636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
637: iex_debug_pub.logmessage('Default StrategyLevel ' || l_DefaultStrategyLevel);

Line 993: from hz_parties a, iex_strategy_work_items w, iex_strategies s

989:
990: cursor c_get_party(p_work_item_id number) is
991: select a.party_id, a.party_type, a.party_name,
992: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
993: from hz_parties a, iex_strategy_work_items w, iex_strategies s
994: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
995:
996: -- bug 4930376 ctlee sql id 14771930, use _all performance
997: cursor c_get_payment(p_delinquency_id number) is

Line 1031: from iex_strategies a, iex_strategy_work_items b

1027: END IF;
1028: begin
1029: select a.strategy_level,b.resource_id,a.strategy_id --Added strategy_id for bug#5502077 schekuri 02-May-2007
1030: into l_strategy_level,l_resource_id,l_strategy_id
1031: from iex_strategies a, iex_strategy_work_items b
1032: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1033: if l_strategy_level is null then
1034: l_strategy_level := 40;
1035: end if;

Line 1275: select party_id from iex_strategies

1271: -- start for bug 9668367 PNAVEENK
1272: l_party_id number;
1273:
1274: cursor c_party_id(p_strategy_id number) is
1275: select party_id from iex_strategies
1276: where strategy_id = p_strategy_id;
1277: -- end for bug 9668367
1278:
1279:

Line 1647: from iex_strategies where strategy_id = l_strategy_id;

1643: --set the session
1644: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
1645:
1646: select decode(strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT', 30, 'BILL_TO', 'DELINQUENCY') into l_strategy_level
1647: from iex_strategies where strategy_id = l_strategy_id;
1648: -- if l_delinquency_id is not null then
1649: if l_strategy_level = 'CUSTOMER' then
1650: begin
1651: -- IF PG_DEBUG < 10 THEN

Line 1868: from iex_strategies a, iex_strategy_work_items b

1864: and b.delinquency_id = p_delinquency_id;
1865:
1866: cursor c_get_witem_temp(p_work_item_id NUMBER) is
1867: select delinquency_id, a.strategy_id
1868: from iex_strategies a, iex_strategy_work_items b
1869: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1870:
1871: -- ctlee using xdo template id
1872: cursor c_get_xdo_template(p_work_item_id NUMBER) is

Line 1883: from hz_parties a, iex_strategy_work_items w, iex_strategies s

1879:
1880: cursor c_get_party(p_work_item_id number) is
1881: select a.party_id, a.party_type, a.party_name,
1882: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
1883: from hz_parties a, iex_strategy_work_items w, iex_strategies s
1884: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
1885:
1886: l_strategy_level number ;
1887: l_DefaultStrategyLevel varchar2(20);

Line 1915: select org_id from iex_strategies where strategy_id = p_strategy_id;

1911: -- end bug 4930376 ctlee - performance 01/09/2006
1912:
1913: -- start for bug 9151851
1914: cursor c_get_org_id ( p_strategy_id number) is
1915: select org_id from iex_strategies where strategy_id = p_strategy_id;
1916: -- end
1917: l_contact_destination varchar2(240); -- bug 3955222
1918: l_contact_party_id number; -- bug 3955222
1919: v_org_id number; -- added for bug 9151851

Line 1958: select a.strategy_level into l_strategy_level from iex_strategies a, iex_strategy_work_items b

1954: l_template_id := l_fulfil_temp_id;
1955: exit;
1956: END LOOP;
1957: begin
1958: select a.strategy_level into l_strategy_level from iex_strategies a, iex_strategy_work_items b
1959: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1960: if l_strategy_level is null then
1961: l_strategy_level := 40;
1962: end if;

Line 2264: from iex_strategies

2260: , p_org_id => v_org_id) = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr
2261: ) */
2262: select decode(strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT', 30, 'BILL_TO', 40, 'DELINQUENCY', 'DELINQUENCY')
2263: into l_DefaultStrategyLevel
2264: from iex_strategies
2265: where strategy_id = l_strategy_id;
2266:
2267: l_dun_yn := iex_utilities.DunningMinAmountCheck(
2268: p_cust_account_id => l_cust_account_id

Line 2350: from iex_strategies

2346: -- set dunning_object_id and dunnint_level
2347: begin
2348: select decode(strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT', 30, 'BILL_TO', 40, 'DELINQUENCY', 'DELINQUENCY')
2349: into l_DefaultStrategyLevel
2350: from iex_strategies
2351: where strategy_id = l_strategy_id;
2352:
2353: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2354: iex_debug_pub.logmessage('resend_fulfillment Default StrategyLevel ' || l_DefaultStrategyLevel);