APPS.CS_SERVICEREQUEST_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 414: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;

410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
412: l_orig_group_type_null varchar2(1) := 'N';
413: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
414: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;
415: --siahmed 12.1.2 project
416: l_request_date DATE;
417: -- end of addition by siahmed
418: BEGIN

Line 12160: FROM jtf_rs_resource_extns_tl

12156: l_service_request_rec.owner_id <> FND_API.G_MISS_NUM) THEN
12157:
12158: SELECT resource_name
12159: INTO l_service_request_rec.owner
12160: FROM jtf_rs_resource_extns_tl
12161: WHERE resource_id = l_service_request_rec.owner_id
12162: AND LANGUAGE = USERENV('LANG');
12163: END IF;
12164:

Line 16504: FROM jtf_rs_resource_extns_tl

16500: -- for bug 2770831 added Begin End and Exception to handle NO_DATA_FOUND.
16501:
16502: BEGIN
16503: SELECT resource_name INTO l_service_request_rec.owner
16504: FROM jtf_rs_resource_extns_tl
16505: WHERE resource_id = l_service_request_rec.owner_id
16506: AND LANGUAGE = USERENV('LANG');
16507: EXCEPTION
16508: WHEN NO_DATA_FOUND THEN