APPS.AMV_USER_PVT dependencies on JTF_RS_ROLE_RELATIONS

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 997: From jtf_rs_role_relations_vl

993: l_date DATE;
994: --
995: CURSOR Check_ResourceRole_csr IS
996: Select role_relate_id
997: From jtf_rs_role_relations_vl
998: Where role_id = l_role_id
999: And role_resource_id = p_resource_id
1000: And role_resource_type = p_resource_type
1001: ;

Line 1171: From jtf_rs_role_relations

1167: CURSOR Check_ResourceRole_csr IS
1168: Select
1169: role_relate_id,
1170: object_version_number
1171: From jtf_rs_role_relations
1172: Where role_id = p_role_id
1173: And role_resource_id = p_resource_id
1174: And role_resource_type = p_resource_type
1175: And delete_flag <> 'Y'

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 1998: From jtf_rs_role_relations_vl

1994: --
1995: CURSOR Get_ResourceRole_csr(p_res_id IN NUMBER) IS
1996: Select
1997: role_relate_id
1998: From jtf_rs_role_relations_vl
1999: Where role_id = p_role_id
2000: And role_resource_id = p_res_id
2001: And role_resource_type = G_RESOURCE_ROLE_CODE
2002: ;

Line 2006: From jtf_rs_role_relations_vl rel

2002: ;
2003: --
2004: CURSOR Get_ResourceRole2_csr(p_res_id IN NUMBER) IS
2005: Select rel.role_relate_id
2006: From jtf_rs_role_relations_vl rel
2007: , jtf_rs_resource_extns res
2008: Where rel.role_id = p_role_id
2009: And rel.role_resource_id = p_res_id
2010: And rel.role_resource_type = G_RESOURCE_ROLE_CODE

Line 2025: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,

2021: From dual
2022: Where exists
2023: (
2024: select r.role_id
2025: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,
2026: jtf_rs_group_usages usg
2027: where m.resource_id = p_res_id
2028: and m.delete_flag <> 'Y'
2029: and m.group_id = r.role_resource_id

Line 2043: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,

2039: From dual
2040: Where exists
2041: (
2042: select r.role_id
2043: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,
2044: jtf_rs_groups_vl g, jtf_rs_group_usages usg
2045: where m.resource_id = p_res_id
2046: and m.delete_flag <> 'Y'
2047: and m.group_id = r.role_resource_id

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

Line 3152: From jtf_rs_role_relations_vl

3148: --
3149: CURSOR Get_GroupRole_csr IS
3150: Select
3151: role_relate_id
3152: From jtf_rs_role_relations_vl
3153: Where role_id = p_role_id
3154: And role_resource_id = p_group_id
3155: And role_resource_type = G_GROUP_ROLE_CODE
3156: ;

Line 3161: From jtf_rs_role_relations_vl r, jtf_rs_groups_vl g

3157: --
3158: CURSOR Get_GroupRole2_csr IS
3159: Select
3160: r.role_relate_id
3161: From jtf_rs_role_relations_vl r, jtf_rs_groups_vl g
3162: Where r.role_id = p_role_id
3163: And r.role_resource_id = p_group_id
3164: And r.role_resource_type = G_GROUP_ROLE_CODE
3165: And r.start_date_active < sysdate