DBA Data[Home] [Help]

APPS.JTF_CAL_UTILITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 69: FROM jtf_rs_resource_extns_tl jrt

65: AND jrt.language = userenv('LANG');
66:
67: CURSOR c_GetInduvidualInfo(b_resource_id IN NUMBER)
68: IS SELECT jrt.resource_name
69: FROM jtf_rs_resource_extns_tl jrt
70: WHERE jrt.resource_id = b_resource_id
71: AND jrt.language = userenv('LANG');
72:
73: l_ResourceInfo VARCHAR2(360);

Line 190: , jtf_rs_resource_extns_tl jrt

186: CURSOR c_ResourceInfo
187: IS SELECT jrb.resource_id ResourceID
188: , jrt.resource_name ResourceName
189: FROM jtf_rs_resource_extns jrb
190: , jtf_rs_resource_extns_tl jrt
191: WHERE jrb.resource_id = jrt.resource_id
192: AND jrt.language = userenv('LANG')
193: AND jrb.user_id = to_number(fnd_profile.value('USER_ID'));
194:

Line 233: , jtf_rs_resource_extns_tl jrt

229: ) IS SELECT jrb.resource_id ResourceID
230: , 'RS_'||jrb.category ResourceType
231: , jrt.resource_name ResourceName
232: FROM jtf_rs_resource_extns jrb
233: , jtf_rs_resource_extns_tl jrt
234: WHERE jrb.resource_id = jrt.resource_id
235: AND jrt.language = userenv('LANG')
236: AND jrb.user_id = b_UserID;
237: