APPS.AMV_USER_PVT dependencies on JTF_RS_ROLES_VL

Line 64: From jtf_rs_roles_vl

60: --
61: CURSOR Get_MES_Role_Id_csr (p_role_code IN VARCHAR2) IS
62: Select
63: role_id
64: From jtf_rs_roles_vl
65: Where role_code = p_role_code
66: And role_type_code = G_MES_ROLE_TYPE_NAME
67: ;
68: l_role_id number := FND_API.G_MISS_NUM;

Line 84: From jtf_rs_roles_vl rol, jtf_rs_role_relations_vl rel

80:
81: CURSOR check_role_csr(p_role_code IN VARCHAR2) IS
82: Select
83: rol.role_id
84: From jtf_rs_roles_vl rol, jtf_rs_role_relations_vl rel
85: Where rol.role_id = rel.role_id
86: And rel.role_resource_id = p_resource_id
87: And rel.role_resource_type = p_resource_type
88: And rol.role_type_code = G_MES_ROLE_TYPE_NAME

Line 1870: From jtf_rs_role_relations_vl rel, jtf_rs_roles_vl rol

1866: CURSOR Get_ResourceRole_csr IS
1867: Select
1868: rol.role_code,
1869: rol.role_id
1870: From jtf_rs_role_relations_vl rel, jtf_rs_roles_vl rol
1871: Where rel.role_resource_id = p_resource_id
1872: And rel.role_resource_type = G_RESOURCE_ROLE_CODE
1873: And rel.role_id = rol.role_id
1874: And rol.role_type_code = G_MES_ROLE_TYPE_NAME

Line 3026: From jtf_rs_role_relations_vl rel, jtf_rs_roles_vl rol

3022: CURSOR Get_GroupRole_csr IS
3023: Select
3024: rol.role_code,
3025: rol.role_id
3026: From jtf_rs_role_relations_vl rel, jtf_rs_roles_vl rol
3027: Where rol.role_id = rel.role_id
3028: And rel.role_resource_id = p_group_id
3029: And rel.role_resource_type = G_GROUP_ROLE_CODE
3030: And rol.role_type_code = G_MES_ROLE_TYPE_NAME