APPS.ASO_SECURITY_INT dependencies on JTF_RS_ROLE_RELATIONS

Line 988: FROM jtf_rs_role_relations rel, jtf_rs_roles_b rolb

984: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
985:
986: CURSOR C_get_resource_role ( l_resource_id NUMBER) IS
987: SELECT rel.role_id
988: FROM jtf_rs_role_relations rel, jtf_rs_roles_b rolb
989: WHERE rel.role_id = rolb.role_id
990: AND rolb.role_type_code = 'SALES'
991: AND NVL(rolb.active_flag, 'Y') <> 'N'
992: AND NVL(rel.delete_flag , 'N') <> 'Y'