DBA Data[Home] [Help]

APPS.BIM_DBI_MKTG_MGMT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 34: FROM JTF_RS_RESOURCE_EXTNS

30: FUNCTION GET_RESOURCE_ID return NUMBER IS
31: l_resource_id NUMBER := NULL;
32: CURSOR c_rid IS
33: SELECT resource_id
34: FROM JTF_RS_RESOURCE_EXTNS
35: WHERE user_id = FND_GLOBAL.user_id;
36: BEGIN
37: OPEN c_rid;
38: FETCH c_rid INTO l_resource_id;

Line 77: FROM JTF_RS_RESOURCE_EXTNS r, bim_i_admin_group a

73: l_admin_count NUMBER := 0;
74: l_admin_flag varchar2(20) ;
75: CURSOR c_rid IS
76: SELECT count(*)
77: FROM JTF_RS_RESOURCE_EXTNS r, bim_i_admin_group a
78: WHERE user_id = FND_GLOBAL.user_id
79: AND r.resource_id = a.resource_id;
80:
81: BEGIN