APPS.JTF_CAL_UTILITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 15: FROM jtf_rs_resource_extns jrb

11:
12: CURSOR c_GetInfo
13: ( b_resource_id IN NUMBER
14: )IS SELECT jrb.user_name
15: FROM jtf_rs_resource_extns jrb
16: WHERE jrb.resource_id = b_resource_id;
17:
18: l_UserName VARCHAR2(360);
19:

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 154: FROM jtf_rs_resource_extns jrb

150: CURSOR c_ResourceInfo
151: ( b_UserID NUMBER
152: )IS SELECT jrb.resource_id ResourceID
153: , 'RS_'||jrb.category ResourceType
154: FROM jtf_rs_resource_extns jrb
155: WHERE jrb.user_id = b_UserID;
156:
157: r_ResourceInfo c_ResourceInfo%ROWTYPE;
158:

Line 189: FROM jtf_rs_resource_extns jrb

185: )IS
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'));

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 232: FROM jtf_rs_resource_extns jrb

228: ( b_UserID NUMBER
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;

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:

Line 1409: FROM jtf_rs_resource_extns jrb

1405:
1406: CURSOR c_GetInfo
1407: ( b_resource_id IN NUMBER
1408: )IS SELECT jrb.user_id
1409: FROM jtf_rs_resource_extns jrb
1410: WHERE jrb.resource_id = b_resource_id;
1411:
1412: l_UserID NUMBER;
1413: