DBA Data[Home] [Help]

APPS.PVX_UTILITY_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 89: FROM jtf_rs_role_relations role_reln, jtf_rs_roles_vl rl

85: is_vendor_admin varchar2(1):=FND_API.g_false;
86:
87: CURSOR isvendor_csr(p_res_id NUMBER) IS
88: SELECT 'Y'
89: FROM jtf_rs_role_relations role_reln, jtf_rs_roles_vl rl
90: WHERE rl.ROLE_TYPE_CODE = 'PRM'
91: AND rl.role_code = 'PV_VENDOR_ADMINISTRATOR'
92: AND rl.role_id = role_reln.role_id
93: AND role_reln.role_resource_type = 'RS_INDIVIDUAL'