APPS.IEX_STRATEGY_WORK_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 55: select user_id from jtf_rs_resource_extns

51: --jsanju 04/09 -- fulfillment resource id
52: l_resource_id NUMBER;
53:
54: cursor c_getuserid(l_resource_id NUMBER) is
55: select user_id from jtf_rs_resource_extns
56: where resource_id =l_resource_id;
57:
58: l_user_id NUMBER;
59: -- ctlee, add for create dunning

Line 90: , wf_item_types_tl item, jtf_rs_resource_extns res

86: SELECT
87: wkitem.resource_id ASSIGNED_TO
88: from
89: iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl
90: , wf_item_types_tl item, jtf_rs_resource_extns res
91: WHERE
92: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
93: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id
94: and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG')

Line 951: from jtf_rs_resource_extns

947: ( p_resource_id IN NUMBER,
948: x_username OUT NOCOPY VARCHAR2 ) IS
949: cursor c_getname(p_resource_id NUMBER) is
950: Select user_name
951: from jtf_rs_resource_extns
952: where resource_id =p_resource_id;
953:
954: BEGIN
955: -- IF PG_DEBUG < 10 THEN

Line 1040: -- get user name from jtf_rs_resource_extns

1036: EXCEPTION WHEN OTHERS THEN
1037: l_strategy_level := 40; -- default to delinquency level
1038: end;
1039:
1040: -- get user name from jtf_rs_resource_extns
1041: if (l_resource_id is not null) THEN
1042: get_username( p_resource_id =>l_resource_id,
1043: x_username =>l_username);
1044: else

Line 1826: select user_id from jtf_rs_resource_extns

1822: --jsanju 04/09 -- fulfillment resource id
1823: l_resource_id NUMBER;
1824: l_del_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
1825: cursor c_getuserid(l_resource_id NUMBER) is
1826: select user_id from jtf_rs_resource_extns
1827: where resource_id =l_resource_id;
1828:
1829: l_user_id NUMBER;
1830: -- ctlee, add for create dunning

Line 1898: , wf_item_types_tl item, jtf_rs_resource_extns res

1894: SELECT
1895: wkitem.resource_id ASSIGNED_TO
1896: from
1897: iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl
1898: , wf_item_types_tl item, jtf_rs_resource_extns res
1899: WHERE
1900: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
1901: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id
1902: and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG')