APPS.IEX_STRATEGY_WORK_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 54: select user_id from jtf_rs_resource_extns

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

Line 89: , wf_item_types_tl item, jtf_rs_resource_extns res

85: SELECT
86: wkitem.resource_id ASSIGNED_TO
87: from
88: 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
89: , wf_item_types_tl item, jtf_rs_resource_extns res
90: WHERE
91: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
92: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id
93: and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG')

Line 724: from jtf_rs_resource_extns

720: ( p_resource_id IN NUMBER,
721: x_username OUT NOCOPY VARCHAR2 ) IS
722: cursor c_getname(p_resource_id NUMBER) is
723: Select user_name
724: from jtf_rs_resource_extns
725: where resource_id =p_resource_id;
726:
727: BEGIN
728: -- IF PG_DEBUG < 10 THEN

Line 813: -- get user name from jtf_rs_resource_extns

809: EXCEPTION WHEN OTHERS THEN
810: l_strategy_level := 40; -- default to delinquency level
811: end;
812:
813: -- get user name from jtf_rs_resource_extns
814: if (l_resource_id is not null) THEN
815: get_username( p_resource_id =>l_resource_id,
816: x_username =>l_username);
817: else

Line 1578: select user_id from jtf_rs_resource_extns

1574: --jsanju 04/09 -- fulfillment resource id
1575: l_resource_id NUMBER;
1576:
1577: cursor c_getuserid(l_resource_id NUMBER) is
1578: select user_id from jtf_rs_resource_extns
1579: where resource_id =l_resource_id;
1580:
1581: l_user_id NUMBER;
1582: -- ctlee, add for create dunning

Line 1650: , wf_item_types_tl item, jtf_rs_resource_extns res

1646: SELECT
1647: wkitem.resource_id ASSIGNED_TO
1648: from
1649: 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
1650: , wf_item_types_tl item, jtf_rs_resource_extns res
1651: WHERE
1652: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
1653: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id
1654: and stry_temp_wkitem_tl.LANGUAGE = userenv('LANG')