APPS.CS_SERVICEREQUEST_PVT dependencies on JTF_OBJECTS_VL

Line 1852: --select the l_title from jtf_objects_vl

1848:
1849: -- UWQ pop up in service request
1850: -- while creating an SR from Teleservice
1851: l_imp_level := Get_Importance_Level(p_service_request_rec.severity_id);
1852: --select the l_title from jtf_objects_vl
1853: l_title := Get_Title('SR');
1854: -- Assign the value of request_id to the local variable that will be passed to the
1855: -- IEU procedure .
1856: IF l_request_id IS NULL THEN

Line 4822: --select the l_title from jtf_objects_vl

4818: l_imp_level := Get_Importance_Level(l_service_request_rec.severity_id);
4819: l_imp_level_old := Get_Old_Importance_level(p_request_id);
4820: l_old_owner_id := Get_Owner_id(p_request_id);
4821:
4822: --select the l_title from jtf_objects_vl
4823: l_title := Get_Title('SR');
4824:
4825: IF (l_service_request_rec.last_update_channel in ('PHONE', 'AGENT') AND
4826: (l_imp_level_old <> 1 OR l_imp_level_old = 1) AND

Line 19285: FROM jtf_objects_vl

19281: FUNCTION Get_Title(P_Object_Code IN VARCHAR2)
19282: RETURN VARCHAR2 IS
19283: CURSOR c_title_csr IS
19284: SELECT description
19285: FROM jtf_objects_vl
19286: WHERE object_code=P_Object_Code;
19287: --Fixed bug#2802393, changed length from 30 to 80
19288: l_title VARCHAR2(80);
19289: BEGIN