APPS.IEX_WRITEOFFOBJ_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 166: from JTF_RS_RESOURCE_EXTNS a, JTF_RS_RESOURCE_EXTNS b

162: -- SELECT name from wf_roles
163: -- where orig_system = 'FND_RESP'
164: -- and orig_system_id = '23366';
165: select b.user_name
166: from JTF_RS_RESOURCE_EXTNS a, JTF_RS_RESOURCE_EXTNS b
167: where b.source_id = nvl(a.source_mgr_id,a.source_id)
168: and a.user_name = (select fu.user_name from fnd_user fu where fu.user_id = p_id);
169:
170: cursor c_get_ar_invoices(p_object_id IN VARCHAR2) is

Line 306: jtf_rs_resource_extns rs,

302:
303: cursor c_get_case_owner(p_object_id IN VARCHAR2) IS
304: select rs.source_name, chr.contract_number
305: from iex_cases_all_b icas,
306: jtf_rs_resource_extns rs,
307: iex_case_objects ico,
308: okc_k_headers_b chr
309: where ico.cas_id = icas.cas_id
310: and icas.owner_resource_id = rs.resource_id(+)