APPS.JTF_RS_ROLES_PVT dependencies on FND_LOOKUPS

Line 107: SELECT lookup_code from fnd_lookups

103: FROM jtf_rs_roles_vl
104: WHERE role_code = l_role_code;
105:
106: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
107: SELECT lookup_code from fnd_lookups
108: WHERE LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'
109: AND lookup_code = l_role_type_code
110: AND enabled_flag = 'Y'
111: AND trunc(sysdate) <= trunc(nvl(end_date_active,sysdate));

Line 686: SELECT lookup_code from fnd_lookups

682: FROM jtf_rs_roles_vl
683: WHERE role_code = l_role_code;
684:
685: CURSOR c_role_type_code ( l_role_type_code IN jtf_rs_roles_vl.role_type_code%type) IS
686: SELECT lookup_code from fnd_lookups
687: WHERE LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'
688: AND lookup_code = l_role_type_code
689: AND enabled_flag = 'Y'
690: AND trunc(sysdate) <= trunc(nvl(end_date_active,sysdate));