APPS.JTF_RS_ROLE_RELATE_PVT dependencies on FND_LOOKUPS

Line 183: cursor chk_role_type_cur(l_role_type FND_LOOKUPS.LOOKUP_CODE%type)

179: WHERE role_id = l_role_id;
180:
181: role_type_rec get_type_cur%rowtype;
182:
183: cursor chk_role_type_cur(l_role_type FND_LOOKUPS.LOOKUP_CODE%type)
184: is
185: select 'X'
186: from fnd_lookups
187: where lookup_type = 'JTF_RS_ROLE_TYPE'

Line 186: from fnd_lookups

182:
183: cursor chk_role_type_cur(l_role_type FND_LOOKUPS.LOOKUP_CODE%type)
184: is
185: select 'X'
186: from fnd_lookups
187: where lookup_type = 'JTF_RS_ROLE_TYPE'
188: and lookup_code = l_role_type
189: and ENABLED_FLAG = 'Y'
190: and START_DATE_ACTIVE <= p_start_date