APPS.IEX_STRY_UTL_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 1672: FROM JTF_RS_RESOURCE_EXTNS a

1668: and a.resource_id = p_resource_id;
1669:
1670: CURSOR c_manager(p_resource_id NUMBER) IS
1671: SELECT b.user_id, b.user_name , b.resource_id
1672: FROM JTF_RS_RESOURCE_EXTNS a
1673: ,JTF_RS_RESOURCE_EXTNS b
1674: WHERE b.source_id = a.source_mgr_id
1675: AND a.resource_id = p_resource_id;
1676:

Line 1673: ,JTF_RS_RESOURCE_EXTNS b

1669:
1670: CURSOR c_manager(p_resource_id NUMBER) IS
1671: SELECT b.user_id, b.user_name , b.resource_id
1672: FROM JTF_RS_RESOURCE_EXTNS a
1673: ,JTF_RS_RESOURCE_EXTNS b
1674: WHERE b.source_id = a.source_mgr_id
1675: AND a.resource_id = p_resource_id;
1676:
1677: cursor c_getname(p_resource_id NUMBER) is

Line 1679: from jtf_rs_resource_extns

1675: AND a.resource_id = p_resource_id;
1676:
1677: cursor c_getname(p_resource_id NUMBER) is
1678: Select user_name,source_name
1679: from jtf_rs_resource_extns
1680: where resource_id =p_resource_id;
1681:
1682: l_source_name varchar2(50);
1683: l_username varchar2(240);