DBA Data[Home] [Help]

APPS.IEX_STRY_CUWF_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 100: from jtf_rs_resource_extns

96: ( p_resource_id IN NUMBER,
97: x_username OUT NOCOPY VARCHAR2 ) IS
98: cursor c_getname(p_resource_id NUMBER) is
99: Select user_name
100: from jtf_rs_resource_extns
101: where resource_id =p_resource_id;
102:
103: BEGIN
104: OPEN c_getname(p_resource_id);

Line 120: -- get user name from jtf_rs_resource_extns

116: l_mgrname VARCHAR2(100);
117: l_mgr_resource_id NUMBER ;
118: BEGIN
119:
120: -- get user name from jtf_rs_resource_extns
121: get_username
122: ( p_resource_id =>p_resource_id,
123: x_username =>l_username);
124: